public DataTable GetLoginDetails(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_GetLoginDetails", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@username", SqlDbType.NVarChar).Value = objbe.username; da.SelectCommand.Parameters.Add("@year", SqlDbType.NVarChar).Value = objbe.year; da.SelectCommand.Parameters.Add("@Season", SqlDbType.NVarChar).Value = objbe.season; da.SelectCommand.Parameters.Add("@state", SqlDbType.NVarChar).Value = objbe.statecd; da.SelectCommand.Parameters.Add("@dist", SqlDbType.NVarChar).Value = objbe.distcd; da.SelectCommand.Parameters.Add("@mand", SqlDbType.NVarChar).Value = objbe.mandalcd; da.SelectCommand.Parameters.Add("@role", SqlDbType.Int).Value = objbe.role; da.SelectCommand.Parameters.Add("@spcode", SqlDbType.NVarChar).Value = objbe.SPcode; da.SelectCommand.Parameters.Add("@updatedUSer", SqlDbType.NVarChar).Value = objbe.userid; da.SelectCommand.Parameters.Add("@updt_ip", SqlDbType.NVarChar).Value = objbe.ipaddress; da.SelectCommand.Parameters.Add("@newpwd", SqlDbType.NVarChar).Value = objbe.pwd; da.SelectCommand.Parameters.Add("@action", SqlDbType.Char).Value = objbe.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable EmployeeIUDR_Agri(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("EMPLOYEE_IUDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@EmpID", SqlDbType.VarChar).Value = obj.EmpId; da.SelectCommand.Parameters.Add("@EmpCode", SqlDbType.VarChar).Value = obj.Empcode; da.SelectCommand.Parameters.Add("@Dept", SqlDbType.VarChar).Value = obj.Dept; da.SelectCommand.Parameters.Add("@Name", SqlDbType.VarChar).Value = obj.EmpName; da.SelectCommand.Parameters.Add("@Mobile", SqlDbType.VarChar).Value = obj.Mobile; da.SelectCommand.Parameters.Add("@Email", SqlDbType.VarChar).Value = obj.Email; da.SelectCommand.Parameters.Add("@Active", SqlDbType.VarChar).Value = obj.Active; da.SelectCommand.Parameters.Add("@State", SqlDbType.VarChar).Value = obj.statecode; da.SelectCommand.Parameters.Add("@Role", SqlDbType.VarChar).Value = obj.Role; da.SelectCommand.Parameters.Add("@Lab", SqlDbType.VarChar).Value = obj.labid; da.SelectCommand.Parameters.Add("@DistCode", SqlDbType.VarChar).Value = obj.DistCode; da.SelectCommand.Parameters.Add("@zoneCd", SqlDbType.VarChar).Value = obj.ZoneCode; da.SelectCommand.Parameters.Add("@MandCode", SqlDbType.VarChar).Value = obj.MandCode; da.SelectCommand.Parameters.Add("@Address", SqlDbType.VarChar).Value = obj.Address; da.SelectCommand.Parameters.Add("@Desig", SqlDbType.VarChar).Value = obj.DesignationID; da.SelectCommand.Parameters.Add("@UserName", SqlDbType.VarChar).Value = obj.UserName; da.SelectCommand.Parameters.Add("@Action", SqlDbType.VarChar).Value = obj.Action; da.SelectCommand.Parameters.Add("@User", SqlDbType.VarChar).Value = obj.UserID; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
//Daily report public DataTable GetDailyReport(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_Grid_DailyReport_DAO", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@year", SqlDbType.VarChar).Value = objbe.year; da.SelectCommand.Parameters.Add("@season", SqlDbType.VarChar).Value = objbe.season; if (objbe.distcd != "0") { da.SelectCommand.Parameters.Add("@dist", SqlDbType.VarChar).Value = objbe.distcd; } if (objbe.mandalcd != "0") { da.SelectCommand.Parameters.Add("@mand", SqlDbType.VarChar).Value = objbe.mandalcd; } if (objbe.SPcode != "0") { da.SelectCommand.Parameters.Add("@sp", SqlDbType.VarChar).Value = objbe.SPcode; } da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = objbe.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable UserRegistration_IUDR(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("UserReg_IUDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@ID", SqlDbType.VarChar).Value = obj.Id; da.SelectCommand.Parameters.Add("@Name", SqlDbType.VarChar).Value = obj.Name; da.SelectCommand.Parameters.Add("@Depatment", SqlDbType.VarChar).Value = obj.Dept; da.SelectCommand.Parameters.Add("@Role", SqlDbType.VarChar).Value = obj.Role; da.SelectCommand.Parameters.Add("@Desig", SqlDbType.VarChar).Value = obj.DesignationID; da.SelectCommand.Parameters.Add("@Empcode", SqlDbType.VarChar).Value = obj.EmpId; da.SelectCommand.Parameters.Add("@Lab", SqlDbType.VarChar).Value = obj.labid; da.SelectCommand.Parameters.Add("@UserID", SqlDbType.VarChar).Value = obj.UserID; da.SelectCommand.Parameters.Add("@State", SqlDbType.VarChar).Value = obj.statecode; da.SelectCommand.Parameters.Add("@zoneCd", SqlDbType.VarChar).Value = obj.ZoneCode; da.SelectCommand.Parameters.Add("@DistCode", SqlDbType.VarChar).Value = obj.DistCode; da.SelectCommand.Parameters.Add("@MandCode", SqlDbType.VarChar).Value = obj.MandCode; da.SelectCommand.Parameters.Add("@Address", SqlDbType.VarChar).Value = obj.Address; da.SelectCommand.Parameters.Add("@UserName", SqlDbType.VarChar).Value = obj.UserName; da.SelectCommand.Parameters.Add("@Action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
protected void FreezedDataGrid() { dt = new DataTable(); try { objBE = new Master_BE(); objBE.ActionBy = "ADMIN"; objBE.Action = "F"; objBE.Year = ddlYear.SelectedValue.Trim(); objBE.CatId = ddlCategory.SelectedValue.Trim(); dt = ObjDL.TargetAllotment_IUDR(objBE, con); if (dt.Rows.Count > 0) { GVFreezed.DataSource = dt; GVFreezed.DataBind(); FrrezedGridDiv.Visible = true; //btnGetTotal.Visible = true; } else { GVFreezed.DataSource = null; GVFreezed.DataBind(); } } catch (Exception ex) { //ExceptionLogging.SendExcepToDB(ex, Session["UsrName"].ToString(), Request.ServerVariables["REMOTE_ADDR"].ToString()); //Response.Redirect("~/Error.aspx"); } }
//GetCourier Details public DataTable GetCourierDtls(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("MemoIDGeneration", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@Action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable getLoginDetails(Master_BE objBE, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("GetLoginDetails", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@username", SqlDbType.NVarChar).Value = objBE.User; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable GetMandals(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_Grid_DailyReport_DAO", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = objbe.Action; da.SelectCommand.Parameters.Add("@dist", SqlDbType.VarChar).Value = objbe.distcd; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable getSpsDistrict(Master_BE objbe, String ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_ViewSp", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@action", SqlDbType.Char).Value = objbe.Action; da.SelectCommand.Parameters.Add("@dist", SqlDbType.VarChar).Value = objbe.distcd; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public void UpdateUserLoginStatus(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { SqlCommand cmd = new SqlCommand("Seed_UserLoginStatus_IU", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@LoginSno_toUpdate", SqlDbType.BigInt).Value = objbe.userid; cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = objbe.loginStatus; cmd.Parameters.Add("@Login_or_LogoutDateAndTime", SqlDbType.DateTime).Value = objbe.date_time; cmd.Parameters.Add("@Action", SqlDbType.VarChar).Value = objbe.Action; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } }
public DataTable FreezeTargetDetails(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("FreezeTargets", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@tvp", SqlDbType.Structured).Value = obj.TVP; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable HomePageCnts(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("HomePgDashBoard", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@Dept", SqlDbType.VarChar).Value = obj.Dept; da.SelectCommand.Parameters.Add("@Action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable DeleteSeedAllotment(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_AllotDistricts_UDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@action", SqlDbType.Char).Value = "D"; da.SelectCommand.Parameters.Add("@allotid", SqlDbType.VarChar).Value = objbe.allotid; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public string GetSeasonByMonth(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_GetDetails", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@month", SqlDbType.VarChar).Value = objbe.month; da.SelectCommand.Parameters.Add("@action", SqlDbType.Char).Value = objbe.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt.Rows[0][0].ToString()); } } }
public DataTable Issustopsale(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_IssueStopSale", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@action", SqlDbType.Char).Value = obj.Action; da.SelectCommand.Parameters.Add("@tvp", SqlDbType.Structured).Value = obj.TVP; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable GetFreezedAllotmentsbySeason(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_AllotDistricts_UDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@action", SqlDbType.Char).Value = "F1"; da.SelectCommand.Parameters.Add("@Year", SqlDbType.VarChar).Value = objbe.year; da.SelectCommand.Parameters.Add("@season", SqlDbType.VarChar).Value = objbe.season; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable FreezeSeedAllotment(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_Freeze_Allotment_Districts", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@Year", SqlDbType.VarChar).Value = objbe.year; da.SelectCommand.Parameters.Add("@season", SqlDbType.VarChar).Value = objbe.season; da.SelectCommand.Parameters.Add("@tvp", SqlDbType.Structured).Value = objbe.dtfreeze; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable Getdetails(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("GetDetails", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = obj.Action; da.SelectCommand.Parameters.Add("@ID", SqlDbType.VarChar).Value = obj.Id; da.SelectCommand.Parameters.Add("@Catid", SqlDbType.VarChar).Value = obj.CatId; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable ViewRequestDistrict(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_Request_IUDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@year", SqlDbType.VarChar).Value = objbe.year; da.SelectCommand.Parameters.Add("@season", SqlDbType.VarChar).Value = objbe.season; da.SelectCommand.Parameters.Add("@dist", SqlDbType.VarChar).Value = objbe.distcd; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = objbe.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
//Courier Details IUDR public DataTable CourierIUDR(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("CourierDetails_IUDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@tvp", SqlDbType.Structured).Value = obj.TVP; da.SelectCommand.Parameters.Add("@di_id", SqlDbType.VarChar).Value = obj.User; da.SelectCommand.Parameters.Add("@Dept", SqlDbType.VarChar).Value = obj.Dept; da.SelectCommand.Parameters.Add("@Action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable GetLocations(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("GetLocations", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@state", SqlDbType.VarChar).Value = obj.statecode; da.SelectCommand.Parameters.Add("@dist", SqlDbType.VarChar).Value = obj.DistCode; da.SelectCommand.Parameters.Add("@mand", SqlDbType.VarChar).Value = obj.MandCode; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable ViewDistributionDistWs(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_Grid_ViewDistribution", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@dist", SqlDbType.VarChar).Value = objbe.distcd; da.SelectCommand.Parameters.Add("@from", SqlDbType.Date).Value = objbe.frmdt; da.SelectCommand.Parameters.Add("@to", SqlDbType.Date).Value = objbe.todt; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = objbe.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable GetDetails(Master_BE objbe, String ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_DAODashboard", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@action", SqlDbType.Char).Value = objbe.Action; da.SelectCommand.Parameters.Add("@year", SqlDbType.VarChar).Value = objbe.year; da.SelectCommand.Parameters.Add("@season", SqlDbType.VarChar).Value = objbe.season; da.SelectCommand.Parameters.Add("@dist", SqlDbType.VarChar).Value = objbe.distcd; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable GetDetails(Master_BE objbe, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Seed_GetDetails", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@Action", SqlDbType.Char).Value = objbe.Action; da.SelectCommand.Parameters.Add("@StateCode", SqlDbType.VarChar).Value = objbe.statecd; da.SelectCommand.Parameters.Add("@sectionid", SqlDbType.VarChar).Value = objbe.distcd; da.SelectCommand.Parameters.Add("@crop", SqlDbType.VarChar).Value = objbe.mandalcd; da.SelectCommand.Parameters.Add("@extent", SqlDbType.VarChar).Value = objbe.villcode; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable Statemaster_IUDR(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("State_IUDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; //if (obj.StateCode !="0") da.SelectCommand.Parameters.Add("@statecode", SqlDbType.VarChar).Value = obj.statecode; da.SelectCommand.Parameters.Add("@stateName", SqlDbType.VarChar).Value = obj.stateName; da.SelectCommand.Parameters.Add("@user", SqlDbType.VarChar).Value = obj.User; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
//Designation public DataTable DesignationIUDR(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Designation_IUDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@DesignationID", SqlDbType.VarChar).Value = obj.DesignationID; da.SelectCommand.Parameters.Add("@Desig", SqlDbType.VarChar).Value = obj.DesignationName; da.SelectCommand.Parameters.Add("@Dept", SqlDbType.VarChar).Value = obj.Dept; da.SelectCommand.Parameters.Add("@User", SqlDbType.VarChar).Value = obj.UserID; da.SelectCommand.Parameters.Add("@Action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable GenerateMemoID(Master_BE obj, string Conn) { using (SqlConnection con = new SqlConnection(Conn)) { using (SqlDataAdapter da = new SqlDataAdapter("MemoIDGeneration", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@tvpmemo", SqlDbType.Structured).Value = obj.TVP; da.SelectCommand.Parameters.Add("@User", SqlDbType.VarChar).Value = obj.User; da.SelectCommand.Parameters.Add("@statecode", SqlDbType.VarChar).Value = obj.statecode; da.SelectCommand.Parameters.Add("@Depatment", SqlDbType.VarChar).Value = obj.Dept; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
//Test Master public DataTable TestIUDR(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Agri_TestIUDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@TestCode", SqlDbType.VarChar).Value = obj.Testcode; da.SelectCommand.Parameters.Add("@TestaName", SqlDbType.VarChar).Value = obj.TestName; da.SelectCommand.Parameters.Add("@Dept", SqlDbType.VarChar).Value = obj.Dept; da.SelectCommand.Parameters.Add("@user", SqlDbType.VarChar).Value = obj.UserID; da.SelectCommand.Parameters.Add("@Action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable CategoryIUDR(Master_BE obj, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("SampleCategory_IUDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@dept", SqlDbType.VarChar).Value = obj.Dept; da.SelectCommand.Parameters.Add("@cat_id", SqlDbType.VarChar).Value = obj.CatId; da.SelectCommand.Parameters.Add("@cat_name", SqlDbType.VarChar).Value = obj.CatName; da.SelectCommand.Parameters.Add("@user", SqlDbType.VarChar).Value = obj.UserID; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = obj.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable DosageDtls(Master_BE objBE, string ConnKey) { using (SqlConnection con = new SqlConnection(ConnKey)) { using (SqlDataAdapter da = new SqlDataAdapter("Dosage_IUDR", con)) { da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@dept", SqlDbType.Int).Value = objBE.Dept; da.SelectCommand.Parameters.Add("@Id", SqlDbType.Int).Value = objBE.Id; da.SelectCommand.Parameters.Add("@DosageName", SqlDbType.VarChar).Value = objBE.DosageName; da.SelectCommand.Parameters.Add("@UserID", SqlDbType.BigInt).Value = objBE.User; da.SelectCommand.Parameters.Add("@action", SqlDbType.VarChar).Value = objBE.Action; DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }