int leaveReqId = 0; Con = new MySqlConnection(conn); Con.Open(); MySqlCommand cmdLeaveReqId = new MySqlCommand("sp_getLeaveReqId",Con); cmdLeaveReqId.Parameters.Add("@AssociateId", MySqlDbType.Int32).Value = Convert.ToInt32(strAssId.Trim()); cmdLeaveReqId.Parameters.Add("@leaveType", MySqlDbType.String).Value = strLeaveType.Trim(); cmdLeaveReqId.Parameters.Add("@leaveStatus", MySqlDbType.String).Value = strLeaveStatus.Trim(); cmdLeaveReqId.CommandType = CommandType.StoredProcedure; MySqlDataReader drLeaveReqId = cmdLeaveReqId.ExecuteReader(); drLeaveReqId.Read(); leaveReqId = Convert.ToInt32(drLeaveReqId["leave_req_id"].ToString().Trim()); Con.Close(); return leaveReqId;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_getLeaveReqId`(In AssociateId integer,In leaveType varchar(45),in leaveStatus varchar(45)) BEGIN select leave_req_id from leave_request where leave_type_id = (select leave_type_id from leave_type where leave_type=leaveType) and leave_status_id=(select leave_status_id from leave_status where leave_status=leaveStatus) and associate_id=AssociateId; END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)