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);
}
}
}
