public List <Staff> GetAllStaff()
{
var Stafflist = new List <Staff>();
try
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "1"); pcol.Add(p1);
dtloc = DAL.GetDataTable("procStaffMaster", pcol);
CultureInfo provider = CultureInfo.InvariantCulture;
foreach (DataRow row in dtloc.Rows)
{
var obj = new Staff()
{
StaffId = Convert.ToInt32(row["iStaffId"]),
OrganizationName = row["sOrganizationName"].ToString(),
Title = row["sTitle"].ToString(),
StaffName = row["sStaffName"].ToString(),
EmailID = row["sEmailID"].ToString(),
PhoneNo = Convert.ToInt64(row["iPhoneNo"].ToString()),
Active = Convert.ToBoolean(row["bActive"].ToString()),
CreatedOn = Convert.ToDateTime(row["dCreatedOn"])
};
Stafflist.Add(obj);
}
}
catch (Exception ex)
{
DAL.LogFileWrite("Page Url: " + HttpContext.Current.Request.Url + Environment.NewLine + "In GetAllOrganizations " + Environment.NewLine + "Error : " + ex.Message);
}
return(Stafflist);
}
public Organization GetOrganizationById(Organization model)
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "2"); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("OrganizationId", model.OrganizationID); pcol.Add(p2);
dtloc = DAL.GetDataTable("procOrganizationMaster", pcol);
if (dtloc.Rows.Count > 0)
{
model.OrganizationName = dtloc.Rows[0]["sOrganizationName"].ToString();
model.SortName = dtloc.Rows[0]["sSortName"].ToString();
model.Logo = dtloc.Rows[0]["sLogo"].ToString();
model.PhoneNo1 = Convert.ToInt64(dtloc.Rows[0]["iPhoneNo1"].ToString());
model.PhoneNo2 = Convert.ToInt64(dtloc.Rows[0]["iPhoneNo2"].ToString());
model.EmailId = dtloc.Rows[0]["sEmailId"].ToString();
model.SenderEmailId = dtloc.Rows[0]["sSenderEmailId"].ToString();
model.Address = dtloc.Rows[0]["sAddress"].ToString();
model.Category = Convert.ToInt32(dtloc.Rows[0]["iCategory"].ToString());
model.Active = Convert.ToBoolean(dtloc.Rows[0]["bActive"].ToString());
model.LoginName = dtloc.Rows[0]["sLoginName"].ToString();
model.NewPssword = dtloc.Rows[0]["sNewPssword"].ToString();
}
return(model);
}
public List <Plan> GetAllPlans()
{
var planlist = new List <Plan>();
try
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "1"); pcol.Add(p1);
dtloc = DAL.GetDataTable("ProcPlanMaster", pcol);
foreach (DataRow row in dtloc.Rows)
{
var obj = new Plan()
{
PlanId = Convert.ToInt32(row["PlanId"]),
PlanName = row["PlanName"].ToString(),
GracePeriod = Convert.ToInt32(row["GracePeriod"].ToString()),
ActiveDay = Convert.ToInt32(row["ActiveDay"].ToString()),
Price = Convert.ToInt32(row["Price"].ToString()),
Active = Convert.ToBoolean(row["Active"].ToString()),
CreatedOn = Convert.ToDateTime(row["CreatedOn"].ToString())
};
planlist.Add(obj);
}
}
catch (Exception ex)
{
DAL.LogFileWrite("Page Url: " + HttpContext.Current.Request.Url + Environment.NewLine + "In GetAllPlans " + Environment.NewLine + "Error : " + ex.Message);
}
return(planlist);
}
private DataTable AppointmentDetail(int day, int month, int year)
{
DbSqlParameterCollection Msc = new DbSqlParameterCollection();
DbSqlParameter parameterMonth = new DbSqlParameter("@MONTH", SqlDbType.Int, 4);
parameterMonth.Value = month;
Msc.Add(parameterMonth);
DbSqlParameter parameterYear = new DbSqlParameter("@YEAR", SqlDbType.Int, 4);
parameterYear.Value = year;
Msc.Add(parameterYear);
DbSqlParameter parameterDay = new DbSqlParameter("@DAY", SqlDbType.Int, 4);
parameterDay.Value = day;
Msc.Add(parameterDay);
TimeSpan mindiff = UC.LTZ.GetUtcOffset(new DateTime(year, month, 1, 0, 0, 0));
DbSqlParameter parameterLocalTime = new DbSqlParameter("@LTZ", SqlDbType.Int, 4);
parameterLocalTime.Value = Convert.ToInt32(mindiff.TotalMinutes); //localOffset.Minutes;
Msc.Add(parameterLocalTime);
DbSqlParameter parameterOwnerID = new DbSqlParameter("@OWNERID", SqlDbType.Int, 4);
parameterOwnerID.Value = UC.UserId;
Msc.Add(parameterOwnerID);
DataTable appointment = DatabaseConnection.DoStoredTable("APPOINTMENTDETAIL", Msc);
return(appointment);
}
private void AddProcedureParameters()
{
objParamColleciton = new DbSqlParameterCollection();
DbSqlParameter UserNameParam = new DbSqlParameter("@UserName", SqlDbType.VarChar, 50);
UserNameParam.Value = _UserName;
objParamColleciton.Add(UserNameParam);
}
public string DeleteOrganization(Organization model)
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "5"); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("OrganizationId", model.OrganizationID); pcol.Add(p2);
str = DAL.SqlScalartoObj("procOrganizationMaster", pcol).ToString();
return(str);
}
public string TogglePlan(Plan model)
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "5"); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("PlanId", model.PlanId); pcol.Add(p2);
str = DAL.SqlScalartoObj("ProcPlanMaster", pcol).ToString();
return(str);
}
public void Find_Click(object sender, EventArgs e)
{
DbSqlParameter p = new DbSqlParameter("@FINDIT", "%" + FindIt.Text + "%");
string sqlString = "SELECT CRM_OPPORTUNITY.ID, CRM_OPPORTUNITY.TITLE FROM CRM_OPPORTUNITY WHERE CRM_OPPORTUNITY.TITLE LIKE @FINDIT";
RepeaterOpportunity.DataSource = DatabaseConnection.SecureCreateDataset(sqlString, p);
RepeaterOpportunity.DataBind();
}
public string ToggalStaff(Staff model)
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "5"); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("StaffId", model.StaffId); pcol.Add(p2);
str = DAL.SqlScalartoObj("procStaffMaster", pcol).ToString();
return(str);
}
public DataTable GetStateList()
{
objParamCollection = new DbSqlParameterCollection();
DbSqlParameter LookupCodePara = new DbSqlParameter("@LookupCode", SqlDbType.VarChar);
LookupCodePara.Value = "STATE";
objParamCollection.Add(LookupCodePara);
return (CrystalConnection.DoStoredTable("usp_GetLookup", objParamCollection));
}
public DataTable GetLabourTypebyID(int SectorID)
{
objParamCollection = new DbSqlParameterCollection();
DbSqlParameter SectorIDPara = new DbSqlParameter("@SectorId", SqlDbType.Int);
SectorIDPara.Value = SectorID;
objParamCollection.Add(SectorIDPara);
return (CrystalConnection.DoStoredTable("GetLabourTypebySectorId", objParamCollection));
}
public DataTable GetCityListbyStateID(int StateId)
{
objParamCollection = new DbSqlParameterCollection();
DbSqlParameter StateIDPara = new DbSqlParameter("@StateID", SqlDbType.Int);
StateIDPara.Value = StateId;
objParamCollection.Add(StateIDPara);
return (CrystalConnection.DoStoredTable("GetCity_by_StateID", objParamCollection));
}
private void CalendarReminder(int month, int year)
{
DbSqlParameterCollection Msc = new DbSqlParameterCollection();
DbSqlParameter parameterMonth = new DbSqlParameter("@Month", SqlDbType.Int, 4);
parameterMonth.Value = month;
Msc.Add(parameterMonth);
DbSqlParameter parameterYear = new DbSqlParameter("@Year", SqlDbType.Int, 4);
parameterYear.Value = year;
Msc.Add(parameterYear);
TimeSpan mindiff = UC.LTZ.GetUtcOffset(new DateTime(year, month, 1, 0, 0, 0));
DbSqlParameter parameterLocalTime = new DbSqlParameter("@LTZ", SqlDbType.Int, 4);
parameterLocalTime.Value = Convert.ToInt32(mindiff.TotalMinutes); //localOffset.Minutes;
Msc.Add(parameterLocalTime);
DbSqlParameter parameterOwnerID = new DbSqlParameter("@OwnerID", SqlDbType.Int, 4);
parameterOwnerID.Value = UC.UserId;
Msc.Add(parameterOwnerID);
DbSqlParameter parameterDays = new DbSqlParameter("@Days", SqlDbType.VarChar, 1000);
parameterDays.Parameter.Direction = ParameterDirection.Output;
Msc.Add(parameterDays);
try
{
DatabaseConnection.DoStored("NEW_ReminderCalendar", Msc);
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
}
try
{
calReminder = (string)parameterDays.Value;
}
catch
{
calReminder = String.Empty;
}
Trace.Warn("calreminder", calReminder);
}
public string SavePlan(Plan model)
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "3"); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("PlanName", model.PlanName); pcol.Add(p2);
DbSqlParameter p3 = new DbSqlParameter("ActiveDay", model.ActiveDay); pcol.Add(p3);
DbSqlParameter p4 = new DbSqlParameter("GracePeriod", model.GracePeriod); pcol.Add(p4);
DbSqlParameter p5 = new DbSqlParameter("Price", model.Price); pcol.Add(p5);
DbSqlParameter p6 = new DbSqlParameter("CreatedBy", model.CreatedBy); pcol.Add(p6);
str = DAL.SqlScalartoObj("ProcPlanMaster", pcol).ToString();
return(str);
}
public string SaveStaff(Staff model)
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "3"); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("OrganizationID", model.OrganizationId); pcol.Add(p2);
DbSqlParameter p3 = new DbSqlParameter("Title", model.Title); pcol.Add(p3);
DbSqlParameter p4 = new DbSqlParameter("StaffName", model.StaffName); pcol.Add(p4);
DbSqlParameter p5 = new DbSqlParameter("EmailID", model.EmailID); pcol.Add(p5);
DbSqlParameter p6 = new DbSqlParameter("PhoneNo", model.PhoneNo); pcol.Add(p6);
DbSqlParameter p7 = new DbSqlParameter("CreatedBy", model.CreatedBy); pcol.Add(p7);
str = DAL.SqlScalartoObj("procStaffMaster", pcol).ToString();
return(str);
}
public ActionResult Login(Login model)
{
if (ModelState.IsValid) // this is check validity
{
// ProcUserLogin
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("@LoginName", model.UserName); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("@Password", model.Password); pcol.Add(p2);
dt1 = DAL.GetDataTable("ProcUserLogin", pcol);
if (dt1.Rows.Count > 0)
{
int iUserType = Convert.ToInt32(dt1.Rows[0][0].ToString());
FormsAuthentication.RedirectFromLoginPage(dt1.Rows[0]["ID"].ToString(), true);
Session["iUserType"] = dt1.Rows[0]["iUserType"].ToString();
Session["Name"] = dt1.Rows[0]["NAME"].ToString();
if (iUserType == 1 || iUserType == 2)
{
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
else if (iUserType == 3)
{
return(RedirectToAction("Index", "Home", new { area = "Institute" }));
}
else if (iUserType == 4)
{
return(RedirectToAction("Index", "Home", new { area = "Staff" }));
}
else if (iUserType == 5)
{
return(RedirectToAction("Index", "Home", new { area = "Student" }));
}
else
{
ViewBag.danger = "Invalid Account ";
return(View());
}
}
else
{
ViewBag.danger = "Wrong User Name and Password ";
return(View());
}
}
return(View(model));
}
private void btnClone_Click(object sender, EventArgs e)
{
DbSqlParameterCollection Msc = new DbSqlParameterCollection();
DbSqlParameter pID = new DbSqlParameter("@id", SqlDbType.BigInt, 8);
pID.Value = this.QuoteID;
Msc.Add(pID);
DbSqlParameter userID = new DbSqlParameter("@userid", SqlDbType.BigInt, 8);
userID.Value = UC.UserId;
Msc.Add(userID);
object newquote = DatabaseConnection.DoStoredScalar("CloneQuote", Msc, true);
this.FillQuote((long)newquote);
}
private void btnCopyToOrder_Click(object sender, EventArgs e)
{
DbSqlParameterCollection Msc = new DbSqlParameterCollection();
DbSqlParameter pID = new DbSqlParameter("@id", SqlDbType.BigInt, 8);
pID.Value = this.QuoteID;
Msc.Add(pID);
DbSqlParameter userID = new DbSqlParameter("@userid", SqlDbType.BigInt, 8);
userID.Value = UC.UserId;
Msc.Add(userID);
object newquote = DatabaseConnection.DoStoredScalar("QuoteToOrder", Msc, true);
Session["ViewOrder"] = newquote.ToString();
DatabaseConnection.DoCommand("UPDATE QUOTES SET STAGE=6 WHERE ID=" + this.QuoteID);
Response.Redirect("/erp/orderediting.aspx?m=67&dgb=1&si=72");
}
public Plan GetPlanById(Plan model)
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "2"); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("PlanId", model.PlanId); pcol.Add(p2);
dtloc = DAL.GetDataTable("ProcPlanMaster", pcol);
if (dtloc.Rows.Count > 0)
{
model.PlanName = dtloc.Rows[0]["PlanName"].ToString();
model.GracePeriod = Convert.ToInt32(dtloc.Rows[0]["GracePeriod"].ToString());
model.ActiveDay = Convert.ToInt32(dtloc.Rows[0]["ActiveDay"].ToString());
model.Price = Convert.ToInt32(dtloc.Rows[0]["Price"].ToString());
model.Active = Convert.ToBoolean(dtloc.Rows[0]["Active"].ToString());
}
return(model);
}
public Staff GetStaffById(Staff model)
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "2"); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("StaffId", model.StaffId); pcol.Add(p2);
dtloc = DAL.GetDataTable("procStaffMaster", pcol);
if (dtloc.Rows.Count > 0)
{
model.OrganizationId = Convert.ToInt32(dtloc.Rows[0]["sOrganizationName"].ToString());
model.Title = dtloc.Rows[0]["sTitle"].ToString();
model.StaffName = dtloc.Rows[0]["sStaffName"].ToString();
model.EmailID = dtloc.Rows[0]["sEmailID"].ToString();
model.PhoneNo = Convert.ToInt64(dtloc.Rows[0]["iPhoneNo"].ToString());
model.Active = Convert.ToBoolean(dtloc.Rows[0]["bActive"].ToString());
}
return(model);
}
public string SaveOrganization(Organization model)
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "3"); pcol.Add(p1);
DbSqlParameter p2 = new DbSqlParameter("OrganizationName", model.OrganizationName); pcol.Add(p2);
DbSqlParameter p3 = new DbSqlParameter("SortName", model.SortName); pcol.Add(p3);
DbSqlParameter p4 = new DbSqlParameter("Logo", model.Logo); pcol.Add(p4);
DbSqlParameter p5 = new DbSqlParameter("PhoneNo1", model.PhoneNo1); pcol.Add(p5);
DbSqlParameter p6 = new DbSqlParameter("PhoneNo2", model.PhoneNo2); pcol.Add(p6);
DbSqlParameter p7 = new DbSqlParameter("EmailId", model.EmailId); pcol.Add(p7);
DbSqlParameter p8 = new DbSqlParameter("SenderEmailId", model.SenderEmailId); pcol.Add(p8);
DbSqlParameter p9 = new DbSqlParameter("Address", model.Address); pcol.Add(p9);
DbSqlParameter p10 = new DbSqlParameter("Category", model.Category); pcol.Add(p10);
DbSqlParameter p11 = new DbSqlParameter("LoginName", model.LoginName); pcol.Add(p11);
DbSqlParameter p12 = new DbSqlParameter("NewPssword", model.NewPssword); pcol.Add(p12);
DbSqlParameter p13 = new DbSqlParameter("CreatedBy", model.CreatedBy); pcol.Add(p13);
str = DAL.SqlScalartoObj("procOrganizationMaster", pcol).ToString();
return(str);
}
public List <Organization> GetAllOrganizations()
{
var Organizationlist = new List <Organization>();
try
{
pcol = new DbSqlParameterCollection();
DbSqlParameter p1 = new DbSqlParameter("Mode", "1"); pcol.Add(p1);
dtloc = DAL.GetDataTable("procOrganizationMaster", pcol);
CultureInfo provider = CultureInfo.InvariantCulture;
foreach (DataRow row in dtloc.Rows)
{
var obj = new Organization()
{
OrganizationID = Convert.ToInt32(row["iOrganizationID"]),
OrganizationName = row["sOrganizationName"].ToString(),
SortName = row["sSortName"].ToString(),
Logo = row["sLogo"].ToString(),
PhoneNo1 = Convert.ToInt64(row["iPhoneNo1"].ToString()),
PhoneNo2 = Convert.ToInt64(row["iPhoneNo2"].ToString()),
EmailId = row["sEmailId"].ToString(),
SenderEmailId = row["sSenderEmailId"].ToString(),
Address = row["sAddress"].ToString(),
Active = Convert.ToBoolean(row["bActive"].ToString()),
CreatedOn = Convert.ToDateTime(row["dCreatedOn"])
};
Organizationlist.Add(obj);
}
}
catch (Exception ex)
{
DAL.LogFileWrite("Page Url: " + HttpContext.Current.Request.Url + Environment.NewLine + "In GetAllOrganizations " + Environment.NewLine + "Error : " + ex.Message);
}
return(Organizationlist);
}
private void AddProcedureParameters()
{
objParamColleciton = new DbSqlParameterCollection();
DbSqlParameter opModeParam = new DbSqlParameter("@opMode", SqlDbType.VarChar, 25);
opModeParam.Value = _opMode;
objParamColleciton.Add(opModeParam);
DbSqlParameter imageIDParam = new DbSqlParameter("@ImageID", SqlDbType.Decimal);
imageIDParam.Value = _imgID;
objParamColleciton.Add(imageIDParam);
DbSqlParameter imgContentParam = new DbSqlParameter("@ImageContent", SqlDbType.VarBinary);
imgContentParam.Value = _imgContent;
objParamColleciton.Add(imgContentParam);
DbSqlParameter imgExtParam = new DbSqlParameter("@imgExt", SqlDbType.VarChar, 10);
imgExtParam.Value = _imgExt;
objParamColleciton.Add(imgExtParam);
DbSqlParameter mstTableNameParam = new DbSqlParameter("@MasterTblName", SqlDbType.VarChar, 50);
mstTableNameParam.Value = _mstTableName;
objParamColleciton.Add(mstTableNameParam);
DbSqlParameter userIDParam = new DbSqlParameter("@UserID", SqlDbType.Decimal);
userIDParam.Value = _userID;
objParamColleciton.Add(userIDParam);
}
private void AddCustomerProcParam()
{
objCustomerParamCollection = new DbSqlParameterCollection();
DbSqlParameter _opModePara = new DbSqlParameter("@OpMode", SqlDbType.VarChar);
_opModePara.Value = _opmode;
objCustomerParamCollection.Add(_opModePara);
DbSqlParameter CustomerIDPara = new DbSqlParameter("@Customer_ID", SqlDbType.Int);
CustomerIDPara.Value = _customerid;
objCustomerParamCollection.Add(CustomerIDPara);
DbSqlParameter MobileNoPara = new DbSqlParameter("@MobileNo", SqlDbType.VarChar);
MobileNoPara.Value = _mobileno;
objCustomerParamCollection.Add(MobileNoPara);
DbSqlParameter NamePara = new DbSqlParameter("@Name", SqlDbType.VarChar);
NamePara.Value = _name;
objCustomerParamCollection.Add(NamePara);
DbSqlParameter EmailIDPara = new DbSqlParameter("@EmailID", SqlDbType.VarChar);
EmailIDPara.Value = _emailid;
objCustomerParamCollection.Add(EmailIDPara);
DbSqlParameter Address1Para = new DbSqlParameter("@Address1", SqlDbType.VarChar);
Address1Para.Value = _address1;
objCustomerParamCollection.Add(Address1Para);
DbSqlParameter Address2Para = new DbSqlParameter("@Address2", SqlDbType.VarChar);
Address2Para.Value = _address2;
objCustomerParamCollection.Add(Address2Para);
DbSqlParameter PasswordPara = new DbSqlParameter("@Password", SqlDbType.VarChar);
PasswordPara.Value = _password;
objCustomerParamCollection.Add(PasswordPara);
DbSqlParameter TicketPara = new DbSqlParameter("@Ticket", SqlDbType.VarChar);
TicketPara.Value = _ticket;
objCustomerParamCollection.Add(TicketPara);
}
private void AddProcParam()
{
objParamCollection = new DbSqlParameterCollection();
DbSqlParameter _opModePara = new DbSqlParameter("@OpMode", SqlDbType.VarChar);
_opModePara.Value = _opmode;
objParamCollection.Add(_opModePara);
DbSqlParameter LeadIDPara = new DbSqlParameter("@Lead_ID", SqlDbType.Int);
LeadIDPara.Value = _lead_id;
objParamCollection.Add(LeadIDPara);
DbSqlParameter LabourIDPara = new DbSqlParameter("@Labour_ID", SqlDbType.Int);
LabourIDPara.Value = _labourid;
objParamCollection.Add(LabourIDPara);
DbSqlParameter CustomerIDPara = new DbSqlParameter("@Customer_ID", SqlDbType.Int);
CustomerIDPara.Value = _customerid;
objParamCollection.Add(CustomerIDPara);
DbSqlParameter RequiredDatePara = new DbSqlParameter("@Required_Date", SqlDbType.Date);
RequiredDatePara.Value = _required_date;
objParamCollection.Add(RequiredDatePara);
DbSqlParameter RequiredTimePara = new DbSqlParameter("@Required_Time", SqlDbType.VarChar);
RequiredTimePara.Value = _required_time;
objParamCollection.Add(RequiredTimePara);
DbSqlParameter StatusPara = new DbSqlParameter("@Status", SqlDbType.VarChar);
StatusPara.Value = _status;
objParamCollection.Add(StatusPara);
DbSqlParameter AsignPara = new DbSqlParameter("@Asign", SqlDbType.Int);
AsignPara.Value = _asign;
objParamCollection.Add(AsignPara);
DbSqlParameter TicketPara = new DbSqlParameter("@Ticket", SqlDbType.VarChar);
TicketPara.Value = _ticket;
objParamCollection.Add(TicketPara);
//As of now this is not in use changes done on 30th Sept 2015 by GK
//DbSqlParameter DescPara = new DbSqlParameter("@Description", SqlDbType.VarChar);
//DescPara.Value = _description;
//objParamCollection.Add(DescPara);
DbSqlParameter is_accepted = new DbSqlParameter("@is_accepted", SqlDbType.VarChar);
is_accepted.Value = _Is_accepted;
objParamCollection.Add(is_accepted);
DbSqlParameter is_completed = new DbSqlParameter("@is_completed", SqlDbType.VarChar);
is_completed.Value = _Is_completed;
objParamCollection.Add(is_completed);
DbSqlParameter Lead_AdressPara = new DbSqlParameter("@Lead_Address", SqlDbType.VarChar);
Lead_AdressPara.Value = Lead_Address;
objParamCollection.Add(Lead_AdressPara);
}
private void AddUserIDProcParam(int UserID)
{
objCustomerParamCollection = new DbSqlParameterCollection();
DbSqlParameter _UserIDPara = new DbSqlParameter("@userID", SqlDbType.Int);
_UserIDPara.Value = UserID;
objCustomerParamCollection.Add(_UserIDPara);
}
private void AddProcParam()
{
objParamCollection = new DbSqlParameterCollection();
DbSqlParameter _opModePara = new DbSqlParameter("@OpMode", SqlDbType.VarChar);
_opModePara.Value = _opmode;
objParamCollection.Add(_opModePara);
DbSqlParameter Exp_IDPara = new DbSqlParameter("@Exp_ID", SqlDbType.Int);
Exp_IDPara.Value = _exp_id;
objParamCollection.Add(Exp_IDPara);
DbSqlParameter Exp_DatePara = new DbSqlParameter("@Exp_Date", SqlDbType.Date);
Exp_DatePara.Value = _exp_date;
objParamCollection.Add(Exp_DatePara);
DbSqlParameter Exp_TypePara = new DbSqlParameter("@Exp_Type", SqlDbType.VarChar);
Exp_TypePara.Value = _exp_type;
objParamCollection.Add(Exp_TypePara);
DbSqlParameter Exp_AmountPara = new DbSqlParameter("@Exp_Amount", SqlDbType.VarChar);
Exp_AmountPara.Value = _exp_amount;
objParamCollection.Add(Exp_AmountPara);
DbSqlParameter Exp_TowhomePara = new DbSqlParameter("@Exp_ToWhome", SqlDbType.VarChar);
Exp_TowhomePara.Value = _exp_towhome;
objParamCollection.Add(Exp_TowhomePara);
DbSqlParameter Exp_UnderPara = new DbSqlParameter("@Exp_Under", SqlDbType.VarChar);
Exp_UnderPara.Value = _exp_under;
objParamCollection.Add(Exp_UnderPara);
}
private void AddProcParamChangePwd()
{
objParamColleciton = new DbSqlParameterCollection();
DbSqlParameter loginNameParam = new DbSqlParameter("@LoginName", SqlDbType.VarChar, 50);
loginNameParam.Value = _loginName;
objParamColleciton.Add(loginNameParam);
DbSqlParameter pwdParam = new DbSqlParameter("@Pwd", SqlDbType.VarChar, 50);
pwdParam.Value = _pwd;
objParamColleciton.Add(pwdParam);
}
private void AddProcParam_Select()
{
objParamCollection = new DbSqlParameterCollection();
DbSqlParameter _opModePara = new DbSqlParameter("@OpMode", SqlDbType.VarChar);
_opModePara.Value = _opmode;
objParamCollection.Add(_opModePara);
DbSqlParameter Exp_IDPara = new DbSqlParameter("@Exp_ID", SqlDbType.Int);
Exp_IDPara.Value = _exp_id;
objParamCollection.Add(Exp_IDPara);
}
private void AddProcParam()
{
objParamCollection = new DbSqlParameterCollection();
DbSqlParameter OpModePara = new DbSqlParameter("@OpMode", SqlDbType.VarChar);
OpModePara.Value = _opmode;
objParamCollection.Add(OpModePara);
DbSqlParameter Supplier_IDPara = new DbSqlParameter("@Supplier_ID", SqlDbType.Int);
Supplier_IDPara.Value = _supplierid;
objParamCollection.Add(Supplier_IDPara);
DbSqlParameter SupplierCodePara = new DbSqlParameter("@Supplier_Code", SqlDbType.VarChar);
SupplierCodePara.Value = _suppliercode;
objParamCollection.Add(SupplierCodePara);
DbSqlParameter FullNamePara = new DbSqlParameter("@FullName", SqlDbType.VarChar);
FullNamePara.Value = _fullname;
objParamCollection.Add(FullNamePara);
DbSqlParameter AddressPara = new DbSqlParameter("@Address", SqlDbType.VarChar);
AddressPara.Value = _address;
objParamCollection.Add(AddressPara);
DbSqlParameter Sup_StatePara = new DbSqlParameter("@Sup_State", SqlDbType.Int);
Sup_StatePara.Value = _supstate;
objParamCollection.Add(Sup_StatePara);
DbSqlParameter Sup_CityPara = new DbSqlParameter("@Sup_City", SqlDbType.Int);
Sup_CityPara.Value = _supcity;
objParamCollection.Add(Sup_CityPara);
DbSqlParameter Sup_PincodePara = new DbSqlParameter("@Sup_Pincode", SqlDbType.Decimal);
Sup_PincodePara.Value = _suppincode;
objParamCollection.Add(Sup_PincodePara);
DbSqlParameter Mobile_NoPara = new DbSqlParameter("@Sup_Mobile", SqlDbType.Decimal);
Mobile_NoPara.Value = _supmobile;
objParamCollection.Add(Mobile_NoPara);
DbSqlParameter EmailIDPara = new DbSqlParameter("@EmailID", SqlDbType.VarChar);
EmailIDPara.Value = _emailid;
objParamCollection.Add(EmailIDPara);
DbSqlParameter CompanyNamePara = new DbSqlParameter("@CompanyName", SqlDbType.VarChar);
CompanyNamePara.Value = _companyname;
objParamCollection.Add(CompanyNamePara);
DbSqlParameter BankNamePara = new DbSqlParameter("@BankName", SqlDbType.VarChar);
BankNamePara.Value = _bankname;
objParamCollection.Add(BankNamePara);
DbSqlParameter BankAcNoPara = new DbSqlParameter("@Bank_AC_No", SqlDbType.VarChar);
BankAcNoPara.Value = _bankacno;
objParamCollection.Add(BankAcNoPara);
DbSqlParameter Ac_IFSC_CodePara = new DbSqlParameter("@AC_IFCS_Code", SqlDbType.VarChar);
Ac_IFSC_CodePara.Value = _acifsccode;
objParamCollection.Add(Ac_IFSC_CodePara);
DbSqlParameter DocUrl1Para = new DbSqlParameter("@Doc1_Url", SqlDbType.VarChar);
DocUrl1Para.Value = _dock1url;
objParamCollection.Add(DocUrl1Para);
DbSqlParameter DocUrl2Para = new DbSqlParameter("@Doc2_Url", SqlDbType.VarChar);
DocUrl2Para.Value = _dock2url;
objParamCollection.Add(DocUrl2Para);
DbSqlParameter ImageUrlPara = new DbSqlParameter("@Image_Url", SqlDbType.VarChar);
ImageUrlPara.Value = _imageurl;
objParamCollection.Add(ImageUrlPara);
DbSqlParameter MembershipPara = new DbSqlParameter("@Membership", SqlDbType.Char);
MembershipPara.Value = _membership;
objParamCollection.Add(MembershipPara);
}
private void AddProcedureParameters()
{
objParamColleciton = new DbSqlParameterCollection();
DbSqlParameter opModeParam = new DbSqlParameter("@OpMode", SqlDbType.VarChar, 20);
opModeParam.Value = _opMode;
objParamColleciton.Add(opModeParam);
DbSqlParameter userIDParam = new DbSqlParameter("@UserID", SqlDbType.Decimal);
userIDParam.Value = _userID;
objParamColleciton.Add(userIDParam);
DbSqlParameter userNameParam = new DbSqlParameter("@UserName", SqlDbType.VarChar, 50);
userNameParam.Value = _userName;
objParamColleciton.Add(userNameParam);
DbSqlParameter loginNameParam = new DbSqlParameter("@LoginName", SqlDbType.VarChar, 50);
loginNameParam.Value = _loginName;
objParamColleciton.Add(loginNameParam);
DbSqlParameter pwdParam = new DbSqlParameter("@Pwd", SqlDbType.VarChar, 50);
pwdParam.Value = _pwd;
objParamColleciton.Add(pwdParam);
DbSqlParameter userTypeIDParam = new DbSqlParameter("@UserTypeID", SqlDbType.Decimal);
userTypeIDParam.Value = _userTypeID;
objParamColleciton.Add(userTypeIDParam);
DbSqlParameter userCategoryIDParam = new DbSqlParameter("@UserCategoryID", SqlDbType.Decimal);
userCategoryIDParam.Value = _userCategoryID;
objParamColleciton.Add(userCategoryIDParam);
DbSqlParameter EmailIDPara = new DbSqlParameter("@EmailID", SqlDbType.VarChar);
EmailIDPara.Value = _emailid;
objParamColleciton.Add(EmailIDPara);
DbSqlParameter isVerifyParam = new DbSqlParameter("@IsVerify", SqlDbType.Char, 1);
isVerifyParam.Value = _isVerify;
objParamColleciton.Add(isVerifyParam);
DbSqlParameter phoneno = new DbSqlParameter("@phoneno", SqlDbType.Char, 10);
phoneno.Value = _phoneno;
objParamColleciton.Add(phoneno);
DbSqlParameter permanentAdressPara = new DbSqlParameter("@permanentAdress", SqlDbType.VarChar);
permanentAdressPara.Value = permanentAdress;
objParamColleciton.Add(permanentAdressPara);
//Added by khushbu kansal
DbSqlParameter Supcodepara = new DbSqlParameter("@SupCode", SqlDbType.VarChar);
Supcodepara.Value = SupCode;
objParamColleciton.Add(Supcodepara);
//DbSqlParameter ImageURLParam = new DbSqlParameter("@ImageURL", SqlDbType.VarChar);
//ImageURLParam.Value = _imageURL;
//objParamColleciton.Add(ImageURLParam);
}
private void AddProcParam()
{
objParamCollection = new DbSqlParameterCollection();
DbSqlParameter _opModePara = new DbSqlParameter("@OpMode", SqlDbType.VarChar);
_opModePara.Value = _opmode;
objParamCollection.Add(_opModePara);
DbSqlParameter PR_IDPara = new DbSqlParameter("@PR_ID", SqlDbType.Int);
PR_IDPara.Value = _pr_id;
objParamCollection.Add(PR_IDPara);
DbSqlParameter ParticularsPara = new DbSqlParameter("@Particulars", SqlDbType.VarChar);
ParticularsPara.Value = _particulars;
objParamCollection.Add(ParticularsPara);
DbSqlParameter AmountPara = new DbSqlParameter("@Amount", SqlDbType.Decimal);
AmountPara.Value = _amount;
objParamCollection.Add(AmountPara);
DbSqlParameter DatePara = new DbSqlParameter("@Date", SqlDbType.Date);
DatePara.Value = _date;
objParamCollection.Add(DatePara);
DbSqlParameter PurposePara = new DbSqlParameter("@Purpose", SqlDbType.VarChar);
PurposePara.Value = _purpose;
objParamCollection.Add(PurposePara);
}
private void AddProcParam()
{
objParamCollection = new DbSqlParameterCollection();
DbSqlParameter _opModePara = new DbSqlParameter("@OpMode", SqlDbType.VarChar);
_opModePara.Value = _opmode;
objParamCollection.Add(_opModePara);
DbSqlParameter Reg_IDPara = new DbSqlParameter("@Reg_ID", SqlDbType.Int);
Reg_IDPara.Value = _reg_id;
objParamCollection.Add(Reg_IDPara);
DbSqlParameter LabourCodePara = new DbSqlParameter("@Labour_Code", SqlDbType.VarChar);
LabourCodePara.Value = _labourcode;
objParamCollection.Add(LabourCodePara);
DbSqlParameter FullNamePara = new DbSqlParameter("@FullName", SqlDbType.VarChar);
FullNamePara.Value = _fullname;
objParamCollection.Add(FullNamePara);
DbSqlParameter FatherNamePara = new DbSqlParameter("@FatherName", SqlDbType.VarChar);
FatherNamePara.Value = _fathername;
objParamCollection.Add(FatherNamePara);
DbSqlParameter C_AddressPara = new DbSqlParameter("@C_Address", SqlDbType.VarChar);
C_AddressPara.Value = _c_address;
objParamCollection.Add(C_AddressPara);
DbSqlParameter C_StatePara = new DbSqlParameter("@C_State", SqlDbType.Int);
C_StatePara.Value = _c_state;
objParamCollection.Add(C_StatePara);
DbSqlParameter C_CityPara = new DbSqlParameter("@C_City", SqlDbType.Int);
C_CityPara.Value = _c_city;
objParamCollection.Add(C_CityPara);
DbSqlParameter C_PincodePara = new DbSqlParameter("@C_Pincode", SqlDbType.Decimal);
C_PincodePara.Value = _c_pincode;
objParamCollection.Add(C_PincodePara);
DbSqlParameter P_AddressPara = new DbSqlParameter("@P_Address", SqlDbType.VarChar);
P_AddressPara.Value = _p_address;
objParamCollection.Add(P_AddressPara);
DbSqlParameter P_StatePara = new DbSqlParameter("@P_State", SqlDbType.Int);
P_StatePara.Value = _p_state;
objParamCollection.Add(P_StatePara);
DbSqlParameter P_CityPara = new DbSqlParameter("@P_City", SqlDbType.Int);
P_CityPara.Value = _p_city;
objParamCollection.Add(P_CityPara);
DbSqlParameter P_PincodePara = new DbSqlParameter("@P_Pincode", SqlDbType.Decimal);
P_PincodePara.Value = _p_pincode;
objParamCollection.Add(P_PincodePara);
DbSqlParameter Ph_NoPara = new DbSqlParameter("@Ph_No", SqlDbType.Decimal);
Ph_NoPara.Value = _phno;
objParamCollection.Add(Ph_NoPara);
DbSqlParameter SectorTypePara = new DbSqlParameter("@SectorType", SqlDbType.Decimal);
SectorTypePara.Value = _sectortype;
objParamCollection.Add(SectorTypePara);
DbSqlParameter Work_SpecializationPara = new DbSqlParameter("@Work_Specialization", SqlDbType.VarChar);
Work_SpecializationPara.Value = _work_specialization;
objParamCollection.Add(Work_SpecializationPara);
DbSqlParameter ExperiencePara = new DbSqlParameter("@Experience", SqlDbType.VarChar);
ExperiencePara.Value = _experience;
objParamCollection.Add(ExperiencePara);
DbSqlParameter LabourTypePara = new DbSqlParameter("@LabourType", SqlDbType.Int);
LabourTypePara.Value = _labourtype;
objParamCollection.Add(LabourTypePara);
DbSqlParameter Ph_Belonging1Para = new DbSqlParameter("@Ph_belonging1", SqlDbType.Decimal);
Ph_Belonging1Para.Value = _ph_belonging1;
objParamCollection.Add(Ph_Belonging1Para);
DbSqlParameter Ph_Belonging2Para = new DbSqlParameter("@Ph_belonging2", SqlDbType.Decimal);
Ph_Belonging2Para.Value = _ph_belonging2;
objParamCollection.Add(Ph_Belonging2Para);
DbSqlParameter Ph_Belonging3Para = new DbSqlParameter("@Ph_belonging3", SqlDbType.Decimal);
Ph_Belonging3Para.Value = _ph_belonging3;
objParamCollection.Add(Ph_Belonging3Para);
DbSqlParameter Ph_Belonging4Para = new DbSqlParameter("@Ph_belonging4", SqlDbType.Decimal);
Ph_Belonging4Para.Value = _ph_belonging4;
objParamCollection.Add(Ph_Belonging4Para);
DbSqlParameter Experience_TypePara = new DbSqlParameter("@Experience_Type", SqlDbType.Int);
Experience_TypePara.Value = _exp_type;
objParamCollection.Add(Experience_TypePara);
DbSqlParameter VarificationPara = new DbSqlParameter("@Verification", SqlDbType.Char);
VarificationPara.Value = _verification;
objParamCollection.Add(VarificationPara);
DbSqlParameter ImageUrlPara = new DbSqlParameter("@Image_Url", SqlDbType.VarChar);
ImageUrlPara.Value = _imageurl;
objParamCollection.Add(ImageUrlPara);
DbSqlParameter DocUrl1Para = new DbSqlParameter("@Doc1_Url", SqlDbType.VarChar);
DocUrl1Para.Value = _docurl1;
objParamCollection.Add(DocUrl1Para);
DbSqlParameter DocUrl2Para = new DbSqlParameter("@Doc2_Url", SqlDbType.VarChar);
DocUrl2Para.Value = _docurl2;
objParamCollection.Add(DocUrl2Para);
DbSqlParameter DocUrl3Para = new DbSqlParameter("@Doc3_Url", SqlDbType.VarChar);
DocUrl3Para.Value = _docurl3;
objParamCollection.Add(DocUrl3Para);
DbSqlParameter DocUrl4Para = new DbSqlParameter("@Doc4_Url", SqlDbType.VarChar);
DocUrl4Para.Value = _docurl4;
objParamCollection.Add(DocUrl4Para);
DbSqlParameter SupplierIDPara = new DbSqlParameter("@SupplierID", SqlDbType.Int);
SupplierIDPara.Value = _supplierid;
objParamCollection.Add(SupplierIDPara);
DbSqlParameter WagesPara = new DbSqlParameter("@Wages", SqlDbType.VarChar);
WagesPara.Value = _wages;
objParamCollection.Add(WagesPara);
DbSqlParameter Lbr_SkillPara = new DbSqlParameter("@Lbr_Skill", SqlDbType.Int);
Lbr_SkillPara.Value = _Lbr_Skill;
objParamCollection.Add(Lbr_SkillPara);
}