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);
}
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 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));
}
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));
}
private void FillTEvento(int id)
{
DataSet dsContact;
DbSqlParameterCollection p = new DbSqlParameterCollection();
p.Add(new DbSqlParameter("@ID", id));
p.Add(new DbSqlParameter("@UID", ((UC.ImpersonateUser != 0) ? UC.ImpersonateUser : UC.UserId)));
dsContact = DatabaseConnection.SecureCreateDataset("SELECT * FROM BASE_CALENDAR WHERE ID = @ID AND UID = @UID", p);
if (dsContact.Tables[0].Rows.Count > 0)
{
DataRow drContact = dsContact.Tables[0].Rows[0];
NewId.Text = drContact["id"].ToString();
F_StartDate.Text = UC.LTZ.ToLocalTime(Convert.ToDateTime(drContact["startdate"])).ToShortDateString();
F_EndDate.Text = UC.LTZ.ToLocalTime(Convert.ToDateTime(drContact["enddate"])).ToShortDateString();
F_StartHour.Text = UC.LTZ.ToLocalTime(Convert.ToDateTime(drContact["startdate"])).ToShortTimeString();
F_EndHour.Text = UC.LTZ.ToLocalTime(Convert.ToDateTime(drContact["enddate"])).ToShortTimeString();
F_Title.Text = drContact["CONTACT"].ToString();
F_Title2.Text = drContact["Company"].ToString();
Room.Text = drContact["ROOM"].ToString();
Address.Text = drContact["ADDRESS"].ToString();
City.Text = drContact["CITY"].ToString();
Province.Text = drContact["PROVINCE"].ToString();
CAP.Text = drContact["CAP"].ToString();
F_note.Text = drContact["Note"].ToString();
Phone.Text = drContact["Phone"].ToString();
F_ContactID.Text = drContact["ContactID"].ToString();
CompanyId.Text = drContact["CompanyID"].ToString();
if ((bool)drContact["PLACE"])
{
CheckSite.Checked = true;
}
else
{
CheckSite.Checked = false;
}
HiddenStartHour.Value = UC.WorkStartHour;
HiddenEndHour.Value = UC.WorkEndHour;
CheckReminder.Enabled = false;
if (drContact["uid"].ToString() != drContact["SecondUID"].ToString())
{
Companion.Text = DatabaseConnection.SqlScalar("SELECT SURNAME+' '+NAME FROM ACCOUNT WHERE UID=" + drContact["SecondUID"].ToString());
IdCompanion.Text = drContact["SecondUID"].ToString();
}
}
else
{
Response.Redirect("/today.aspx?logoff=true");
}
AddKeepAlive();
}
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 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);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Login())
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>opener.location.href=opener.location.href;self.close();</script>");
}
else
{
StringBuilder sqlString = new StringBuilder();
sqlString.Append("SELECT CRM_CROSSLEAD.*, BASE_COMPANIES.COMPANYNAME AS COMPANYNAME, ");
sqlString.Append("BASE_CONTACTS.SURNAME + ' ' + BASE_CONTACTS.NAME AS CONTACTNAME, ");
sqlString.Append("CRM_OPPORTUNITY.TITLE AS OPPORTUNITYNAME, ");
sqlString.Append("ACCOUNT_1.SURNAME + ' ' + ACCOUNT_1.NAME AS OWNERNAME, ");
sqlString.Append("ACCOUNT_2.SURNAME + ' ' + ACCOUNT_2.NAME AS SALESPERSONNAME, ");
sqlString.Append("COMPANYTYPE.DESCRIPTION AS INDUSTRYNAME, ");
sqlString.Append("CRM_LEADDESCRIPTION1.DESCRIPTION AS STATUSDESCRIPTION, ");
sqlString.Append("CRM_LEADDESCRIPTION2.DESCRIPTION AS RATINGDESCRIPTION, ");
sqlString.Append("CRM_LEADDESCRIPTION3.DESCRIPTION AS PRODUCTINTERESTDESCRIPTION, ");
sqlString.Append("CRM_LEADDESCRIPTION4.DESCRIPTION AS SOURCEDESCRIPTION, ");
sqlString.Append("CRM_LEADDESCRIPTION5.DESCRIPTION AS LEADCURRENCYDESCRIPTION ");
sqlString.Append("FROM CRM_CROSSLEAD ");
sqlString.Append("LEFT OUTER JOIN ACCOUNT ACCOUNT_2 ON CRM_CROSSLEAD.SALESPERSON = ACCOUNT_2.UID ");
sqlString.Append("LEFT OUTER JOIN ACCOUNT ACCOUNT_1 ON CRM_CROSSLEAD.LEADOWNER = ACCOUNT_1.UID ");
sqlString.Append("LEFT OUTER JOIN CRM_OPPORTUNITY ON CRM_CROSSLEAD.ASSOCIATEDOPPORTUNITY = CRM_OPPORTUNITY.ID ");
sqlString.Append("LEFT OUTER JOIN BASE_CONTACTS ON CRM_CROSSLEAD.ASSOCIATEDCONTACT = BASE_CONTACTS.ID ");
sqlString.Append("LEFT OUTER JOIN BASE_COMPANIES ON CRM_CROSSLEAD.ASSOCIATEDCOMPANY = BASE_COMPANIES.ID ");
sqlString.Append("LEFT OUTER JOIN CRM_LEADDESCRIPTION CRM_LEADDESCRIPTION1 ON CRM_CROSSLEAD.STATUS = CRM_LEADDESCRIPTION1.K_ID AND CRM_LEADDESCRIPTION1.LANG='" + UC.Culture.Substring(0, 2) + "' ");
sqlString.Append("LEFT OUTER JOIN CRM_LEADDESCRIPTION CRM_LEADDESCRIPTION2 ON CRM_CROSSLEAD.RATING = CRM_LEADDESCRIPTION2.K_ID AND CRM_LEADDESCRIPTION2.LANG='" + UC.Culture.Substring(0, 2) + "' ");
sqlString.Append("LEFT OUTER JOIN CRM_LEADDESCRIPTION CRM_LEADDESCRIPTION3 ON CRM_CROSSLEAD.PRODUCTINTEREST = CRM_LEADDESCRIPTION3.K_ID AND CRM_LEADDESCRIPTION3.LANG='" + UC.Culture.Substring(0, 2) + "' ");
sqlString.Append("LEFT OUTER JOIN CRM_LEADDESCRIPTION CRM_LEADDESCRIPTION4 ON CRM_CROSSLEAD.SOURCE = CRM_LEADDESCRIPTION4.K_ID AND CRM_LEADDESCRIPTION4.LANG='" + UC.Culture.Substring(0, 2) + "' ");
sqlString.Append("LEFT OUTER JOIN CRM_LEADDESCRIPTION CRM_LEADDESCRIPTION5 ON CRM_CROSSLEAD.LEADCURRENCY = CRM_LEADDESCRIPTION5.K_ID AND CRM_LEADDESCRIPTION5.LANG='" + UC.Culture.Substring(0, 2) + "' ");
sqlString.AppendFormat("LEFT OUTER JOIN COMPANYTYPE ON CRM_CROSSLEAD.INDUSTRY = COMPANYTYPE.K_ID AND COMPANYTYPE.LANG='{0}'", UC.Culture.Substring(0, 2));
DbSqlParameterCollection p = new DbSqlParameterCollection();
p.Add(new DbSqlParameter("@LEADID", int.Parse(Request.Params["id"])));
RepCrossLead.DataSource = DatabaseConnection.SecureCreateDataset(sqlString.ToString() + "WHERE CRM_CROSSLEAD.LEADID=@LEADID ", p).Tables[0].DefaultView;
RepCrossLead.DataBind();
}
}
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);
}
private void FindCompany(int cID)
{
string sqlString = "SELECT CRM_LEADS.ID,(CRM_LEADS.SURNAME+' '+ISNULL(CRM_LEADS.NAME,'')) AS REFERENTE,CRM_LEADS.COMPANYNAME, CRM_LEADS.COMPANYID, CRM_LEADS.EMAIL FROM CRM_LEADS "
+ "WHERE (CRM_LEADS.LIMBO=0 AND ACTIVE=1 AND ((" + GroupsSecure("CRM_LEADS.GROUPS") + ") OR CRM_LEADS.OWNERID=" + UC.UserId + ")) AND (CRM_LEADS.COMPANYID=@COMPANYID) ";
DbSqlParameterCollection par = new DbSqlParameterCollection();
par.Add(new DbSqlParameter("@COMPANYID", cID));
string queryGroup = GroupsSecure("CRM_LEADS.GROUPS", UC);
if (queryGroup.Length > 0)
{
sqlString += String.Format(" AND ({0})", queryGroup);
}
if (UC.Zones.Length > 0)
{
sqlString += String.Format(" AND ({0})", ZoneSecure("CRM_LEADS.COMMERCIALZONE", UC));
}
sqlString += " ORDER BY REFERENTE";
ContactReferrer.DataSource = DatabaseConnection.SecureCreateDataset(sqlString, par);
ContactReferrer.DataBind();
}
private void FillViewCard(int id)
{
string sqlString = "SELECT BASE_CALENDAR.*,CONVERT(VARCHAR(10),BASE_CALENDAR.STARTDATE,105) AS DATA, CONVERT(VARCHAR(5),BASE_CALENDAR.STARTDATE,114) AS DALLE,CONVERT(VARCHAR(5),BASE_CALENDAR.ENDDATE,114) AS ALLE, " +
"(ACCOUNT.SURNAME+' '+ACCOUNT.NAME) AS USERNAME " +
"FROM BASE_CALENDAR LEFT OUTER JOIN ACCOUNT ON BASE_CALENDAR.UID = ACCOUNT.UID WHERE BASE_CALENDAR.ID=@ID AND BASE_CALENDAR.UID=@UID";
DbSqlParameterCollection p = new DbSqlParameterCollection();
p.Add(new DbSqlParameter("@ID", id));
p.Add(new DbSqlParameter("@UID", ((UC.ImpersonateUser != 0) ? UC.ImpersonateUser : UC.UserId)));
DataSet d = DatabaseConnection.SecureCreateDataset(sqlString, p);
if (d.Tables[0].Rows.Count > 0)
{
ViewAppointmentForm.DataSource = d;
ViewAppointmentForm.DataBind();
ViewAppointmentForm.Visible = true;
AppointmentCard.Visible = false;
}
else
{
Response.Redirect("/today.aspx?logoff=true");
}
}
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 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 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 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 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()
{
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 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);
}
public void Btn_Click(object sender, EventArgs e)
{
DataSet dsCSV = null;
if (Cache[UC.UserId + "CSV"] is DataSet)
{
dsCSV = Cache[UC.UserId + "CSV"] as DataSet;
Cache.Remove(UC.UserId + "CSV");
}
else
{
SendError("Cache Expired during import", UC.UserRealName + " - " + UC.UserName);
Context.Items["warning"] = "Cache Expired during import!";
Response.Redirect("/");
}
string tableRef = String.Empty;
int loadedRows = 0;
int savedActivities = 0;
int reduntantRows = 0;
int unmatchingRows = 0;
switch (((LinkButton)sender).ID)
{
case "RefreshRepCategories":
FillRepCategories();
break;
case "CmdLoadData":
GetMap((CRMTables)int.Parse(TableImport.SelectedValue));
tableRef = _CRMtables[int.Parse(TableImport.SelectedValue)];
DataTable dtMatch = XMLDataTable();
DataTable dtMatchFields = XMLDataTable();
bool csvOk = true;
try
{
if (dsCSV.Tables["CSVData"].Rows.Count < 1)
{
csvOk = false;
}
}
catch
{
csvOk = false;
}
if (csvOk)
{
string sqlString = "SELECT * FROM " + tableRef + " WHERE ID = -1";
IDataReader rd = DatabaseConnection.CreateReader(sqlString);
DataTable St = rd.GetSchemaTable();
DataTable dt = new DataTable();
DataColumn dc;
for (int i = 0; i < St.Rows.Count; i++)
{
dc = new DataColumn(St.Rows[i]["ColumnName"].ToString(), Type.GetType(St.Rows[i]["DataType"].ToString()));
dc.Unique = Convert.ToBoolean(St.Rows[i]["IsUnique"]);
dc.AllowDBNull = Convert.ToBoolean(St.Rows[i]["AllowDBNull"]);
dc.ReadOnly = Convert.ToBoolean(St.Rows[i]["IsReadOnly"]);
if (dc.DataType.ToString() == "System.String")
{
dc.MaxLength = (int)St.Rows[i]["ColumnSize"];
}
dt.Columns.Add(dc);
}
DataRow templaterow = dt.NewRow();
foreach (DataRow d in dsCSV.Tables["CSVData"].Rows)
{
bool noImport = false;
string companyId = String.Empty;
string referrerId = String.Empty;
string leadId = String.Empty;
string accountGroupId = String.Empty;
string query = String.Empty;
for (int i = 0; i < dtMatch.Rows.Count; i++)
{
if (dtMatch.Rows[i]["Must"].ToString() == "1" && (Request.Form[dtMatch.Rows[i]["Name"].ToString()] == "0" || d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString().Length == 0))
{
noImport = true;
unmatchingRows++;
break;
}
if (Request.Form[dtMatch.Rows[i]["Name"].ToString()] == "0")
{
continue;
}
if (Request.Form["Check_" + dtMatch.Rows[i]["Name"].ToString()] != null)
{
query += " AND " + dtMatchFields.Rows[i]["TblSrc"].ToString() + "='" + DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString()) + "'";
}
if (dtMatchFields.Rows[i]["TblSrc"].ToString() == "companylink")
{
companyId = DatabaseConnection.SqlScalar(String.Format("SELECT ID FROM BASE_COMPANIES WHERE ({0}) AND LTRIM(RTRIM(COMPANYNAME))='{1}'", GroupsSecure(), DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString())));
}
else if (dtMatchFields.Rows[i]["TblSrc"].ToString() == "referrerlink" && companyId.Length > 0)
{
referrerId = DatabaseConnection.SqlScalar(String.Format("SELECT ID FROM BASE_CONTACTS WHERE ({0}) AND LTRIM(RTRIM(COMPANYNAME))='{1}'", GroupsSecure(), DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString())));
}
else if (dtMatchFields.Rows[i]["TblSrc"].ToString() == "leadlink")
{
leadId = DatabaseConnection.SqlScalar(String.Format("SELECT ID FROM CRM_LEADS WHERE ({0}) AND LTRIM(RTRIM(COMPANYNAME))='{1}'", GroupsSecure(), DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString())));
}
else if (dtMatchFields.Rows[i]["TblSrc"].ToString() == "accountlink")
{
accountGroupId = DatabaseConnection.SqlScalar(String.Format("SELECT CAST(UID AS VARCHAR)+'|'+CAST(GROUPID AS VARCHAR) FROM ACCOUNT ((LTRNAME))+' '+LTRIM(RTRIM(SURNAME)))='{0}' OR (LTRIM(RTRIM(SURNAME))+' '+LTRIM(RTRIM(NAME)))='{0}' OR USERACCOUNT='{0}')", DatabaseConnection.FilterInjection(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString())));
}
}
if (noImport)
{
break;
}
if (query.Length > 0)
{
string empty;
empty = DatabaseConnection.SqlScalar(String.Format("SELECT COUNT(*) FROM {0} WHERE {1}", tableRef, query));
if (empty != "0")
{
d["DUP"] = true;
}
}
if (!(bool)d["DUP"])
{
DataRow myDataRow = templaterow;
string group = UC.UserGroupId.ToString();
string uId = UC.UserId.ToString();
if (accountGroupId.Length > 0)
{
string[] arr = accountGroupId.Split('|');
uId = arr[0];
group = arr[1];
}
myDataRow["OwnerID"] = uId;
myDataRow["CreatedByID"] = uId;
if (companyId.Length > 0)
{
myDataRow["CompanyID"] = companyId;
}
myDataRow["Groups"] = "|" + group + "|";
if (tableRef.Equals("CRM_WorkActivity"))
{
bool skip = true;
myDataRow["Type"] = "7";
if (referrerId.Length > 0)
{
skip = false;
myDataRow["ReferrerID"] = referrerId;
}
if (leadId.Length > 0)
{
skip = false;
myDataRow["LeadID"] = leadId;
}
if (companyId.Length > 0)
{
skip = false;
}
if (skip)
{
savedActivities++;
continue;
}
}
string cat = "|";
foreach (RepeaterItem it in RepCategories.Items)
{
CheckBox Check = (CheckBox)it.FindControl("Check");
if (Check.Checked)
{
cat += ((Literal)it.FindControl("IDCat")).Text + "|";
}
}
if (cat.Length > 1)
{
myDataRow["Categories"] = cat;
}
for (int i = 0; i < dtMatch.Rows.Count; i++)
{
if (Request.Form[dtMatch.Rows[i]["Name"].ToString()] != "0" &&
dtMatchFields.Rows[i]["TblSrc"].ToString() != "companylink" &&
dtMatchFields.Rows[i]["TblSrc"].ToString() != "referrerlink" &&
dtMatchFields.Rows[i]["TblSrc"].ToString() != "leadlink" &&
dtMatchFields.Rows[i]["TblSrc"].ToString() != "accountlink")
{
int fieldLen = dt.Columns[dtMatchFields.Rows[i]["TblSrc"].ToString()].MaxLength;
if (myDataRow.Table.Columns[dtMatchFields.Rows[i]["TblSrc"].ToString()].DataType.ToString() == "System.Decimal")
{
try
{
decimal dec = StaticFunctions.FixDecimal(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString());
myDataRow[dtMatchFields.Rows[i]["TblSrc"].ToString()] = dec;
}
catch
{
}
}
else if (myDataRow.Table.Columns[dtMatchFields.Rows[i]["TblSrc"].ToString()].DataType.ToString() == "System.DateTime")
{
DateTime today = new DateTime();
try
{
today = DateTime.Parse(d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString().Trim(new char[] { '"', '\'', '\t', ' ' }));
}
catch
{
today = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 12, 0, 0);
}
finally
{
myDataRow[dtMatchFields.Rows[i]["TblSrc"].ToString()] = UC.LTZ.ToUniversalTime(today);
}
}
else if (fieldLen > 4000) //2147483647
{
myDataRow[dtMatchFields.Rows[i]["TblSrc"].ToString()] = d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString().Replace("\r", "").Replace("\n", ((char)13 + (char)10).ToString());
}
else
{
try
{
string colcontent = d[Request.Form[dtMatch.Rows[i]["Name"].ToString()]].ToString().Trim(new char[] { '"', '\'', '\t', ' ' });
if (colcontent.Length > fieldLen)
{
colcontent = colcontent.Substring(0, fieldLen - 1);
}
myDataRow[dtMatchFields.Rows[i]["TblSrc"].ToString()] = colcontent;
}
catch
{
}
}
}
}
switch ((CRMTables)int.Parse(TableImport.SelectedValue))
{
case CRMTables.Base_Companies:
if (myDataRow["CompanyName"] == DBNull.Value)
{
myDataRow["CompanyName"] = "N/A";
}
break;
case CRMTables.Base_Contacts:
case CRMTables.CRM_Leads:
if (myDataRow["Surname"] == DBNull.Value)
{
myDataRow["Surname"] = "N/A";
}
break;
case CRMTables.CRM_WorkActivity:
if (myDataRow["Subject"] == DBNull.Value)
{
myDataRow["Subject"] = "N/A";
}
break;
}
StringBuilder sbColumn = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
sbColumn.AppendFormat("INSERT INTO {0} (", tableRef);
sbValue.Append(" VALUES (");
DbSqlParameterCollection sqlParam = new DbSqlParameterCollection();
foreach (DataColumn cc in myDataRow.Table.Columns)
{
if (cc.ColumnName.ToUpper() != "ID" && myDataRow[cc.ColumnName] != DBNull.Value)
{
sbColumn.AppendFormat("{0},", cc.ColumnName);
sbValue.AppendFormat("@{0},", cc.ColumnName);
sqlParam.Add(new DbSqlParameter("@" + cc.ColumnName, myDataRow[cc.ColumnName]));
}
}
DatabaseConnection.DoCommand(string.Format("{0}){1});", sbColumn.ToString(0, sbColumn.Length - 1), sbValue.ToString(0, sbValue.Length - 1)), sqlParam);
loadedRows++;
}
else
{
reduntantRows++;
}
}
LblInfo.Text = Root.rm.GetString("Csvtxt9") + loadedRows.ToString() + "<br>" +
Root.rm.GetString("Csvtxt10") + reduntantRows.ToString() + "<br>" +
Root.rm.GetString("Csvtxt10") + unmatchingRows.ToString();
UploadForm.Visible = false;
dataform.Visible = false;
Matchdiv.Visible = false;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "NoData", "<script>alert('" + Root.rm.GetString("Csvtxt26") + "');</script>");
}
break;
}
HelpLabel.Visible = false;
Session.Remove("CSV");
}
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 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 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 AddUserIDProcParam(int UserID)
{
objCustomerParamCollection = new DbSqlParameterCollection();
DbSqlParameter _UserIDPara = new DbSqlParameter("@userID", SqlDbType.Int);
_UserIDPara.Value = UserID;
objCustomerParamCollection.Add(_UserIDPara);
}
public DataTable GetSectorType()
{
objParamCollection = new DbSqlParameterCollection();
return (CrystalConnection.DoStoredTable("GetSectorType", objParamCollection));
}
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);
}
