private void defaultPopClients()
{
List<ClientBE> objClientBE = new List<ClientBE>();
// objClientBE = objClientDA.GetClientDetailDA(objUtil.FormDBDate(DateTime.Now.AddMonths(-3)), objUtil.FormDBDate(DateTime.Now.AddMonths(3)));
dpFrom.SelectedDate = DateTime.Now.AddDays(-30);
dpTo.SelectedDate = DateTime.Now.AddDays(30);
objClientBE = objClientDA.GetClientDetailDA(objUtil.FormDBDate(DateTime.Now.AddDays(-30)), objUtil.FormDBDate(DateTime.Now.AddDays(30)));
tgrdClientList.DataSource = objClientBE;
tgrdClientList.DataBind();
}
private void popClients()
{
string errMsg = "";
List<ClientBE> objClientBE = new List<ClientBE>();
//ClientDA objClientDA = new ClientDA();
string dt1 = "", dt2 = "";
lblFilterError.Text = "";
if (dpFrom.SelectedDate.ToString() != "")
dt1 = objUtil.FormDBDate(Convert.ToDateTime(dpFrom.SelectedDate));
if (dpTo.SelectedDate.ToString() != "")
dt2 = objUtil.FormDBDate(Convert.ToDateTime(dpTo.SelectedDate));
if (dt1 != "" && dt2 != "")
{
TimeSpan span = (Convert.ToDateTime(dpTo.SelectedDate)).Subtract(Convert.ToDateTime(dpFrom.SelectedDate));
if (span.Days < 0)
errMsg = objError.getMessage("SS0002");
}
if (errMsg != "")
{
lblFilterError.Text = errMsg;
//tgrdClientList.DataSource = null;
//tgrdClientList.DataBind();
}
//else
//{
objClientBE = objClientDA.GetClientDetailDA(txtSearch.Text.Trim(), rcmbPkgType.SelectedValue, dt1, dt2);
tgrdClientList.DataSource = objClientBE;
tgrdClientList.DataBind();
//}
}
public void SaveDefaultClientConfigDA(ClientBE objClientBE, int CreatedBy)
{
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
using (MySqlCommand sqlCmd = new MySqlCommand("spClientDefaultConfigUpdate", sqlCon))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pTimezoneID", objClientBE.TimeZoneID));
sqlCmd.Parameters.Add(new MySqlParameter("pLanguageID", objClientBE.LanguageID));
sqlCmd.Parameters.Add(new MySqlParameter("pDateFormat", objClientBE.DateFormat));
sqlCmd.Parameters.Add(new MySqlParameter("pIsAutoDLSave", objClientBE.isAutoDLSave));
sqlCmd.Parameters.Add(new MySqlParameter("pClientID", objClientBE.ClientID));
sqlCmd.Parameters.Add(new MySqlParameter("pCreatedBy", CreatedBy));
sqlCmd.Connection.Open();
sqlCmd.ExecuteNonQuery();
sqlCmd.Connection.Close();
}
}
}
catch (Exception Ex)
{
throw Ex;
}
}
private void getClientDetail(int clientID)
{
string modifiedOn = "";
List<ClientBE> objClientBE = new List<ClientBE>();
objClientBE = objClientDA.GetClientDetailDA(clientID);
if (objClientBE.Count > 0)
{
rcmbStatus.Enabled = true;
hClientID.Value = clientID.ToString();
txtClientName.Text = objClientBE[0].ClientName;
txtAddress.Text = objClientBE[0].Address1;
txtCity.Text = objClientBE[0].City;
txtNoUsers.Text = objClientBE[0].NoOfUsers.ToString();
txtPhone.Text = objClientBE[0].Phone;
txtPostcode.Text = objClientBE[0].PostCode;
txtState.Text = objClientBE[0].State;
txtWebsite.Text = objClientBE[0].Website;
rcmbCountry.SelectedValue = objClientBE[0].CountryID.ToString();
rcmbIndustry.SelectedValue = objClientBE[0].IndustryID.ToString();
rcmbRevenue.SelectedValue = objClientBE[0].AnnualRevID.ToString();
if (chkPackage.Items.Count > 2)
{
chkPackage.Items.RemoveAt(2);
}
if (objClientBE[0].CurrentPkgSubscribed == "Custom")
{
chkPackage.Items.Add(new ListItem("Custom", "Custom"));
}
chkPackage.SelectedValue = objClientBE[0].CurrentPkgSubscribed;
rcmbStatus.SelectedValue = objClientBE[0].ClientStatus;
hCurrStatus.Value = objClientBE[0].ClientStatus;
modifiedOn = objClientBE[0].LastModified;
hCurrPkg.Value = objClientBE[0].CurrentPkgSubscribed;
//dvStep.Visible = true;
int[] usrCount = objUserDA.GetClientUserCountDA(clientID);
if (usrCount[0].ToString() == "1")
lblActiveUserCnt.Text = " (" + usrCount[0].ToString() + " Active User)";
else
lblActiveUserCnt.Text = " (" + usrCount[0].ToString() + " Active Users)";
hActiveUserCnt.Value = usrCount[0].ToString();
}
List<ContactBE> objContactBE = new List<ContactBE>();
objContactBE = objClientDA.GetClientContactDA(clientID);
if (objContactBE.Count > 0)
{
hContactID.Value = objContactBE[0].ContactID.ToString();
txtContactName.Text = objContactBE[0].Contactname;
txtContactEmail.Text = objContactBE[0].Email;
txtContactPhone.Text = objContactBE[0].Phone;
txtContactDepart.Text = objContactBE[0].Department;
txtJobTitle.Text = objContactBE[0].JobTitle;
}
List<UserBE> objUserBE = new List<UserBE>();
objUserBE = objUserDA.GetPrimaryAdminDA(clientID);
if (objUserBE.Count > 0)
{
hAdminID.Value = objUserBE[0].UserID.ToString();
txtAdminFName.Text = objUserBE[0].FirstName;
txtAdminLName.Text = objUserBE[0].LastName;
txtAdminEmail.Text = objUserBE[0].EmailID;
txtAdminPhone.Text = objUserBE[0].Telephone;
txtAdminDept.Text = objUserBE[0].Department;
}
if (hCurrStatus.Value == "Inactive")
{
dvAlert.Visible = true;
System.TimeSpan diffResult = DateTime.Now - Convert.ToDateTime(modifiedOn);
string[] arrValues = new string[1];
arrValues[0] = Convert.ToString(diffResult.Days);
lblInactiveMsg.Text = objError.getMessage("SS0001", arrValues);
btnSave.Visible = false;
btnActivate.Visible = true;
//rcmbStatus.Visible = false;
PlaceHolderReactivate.Visible = true;
PlaceHolderActive.Visible = false;
}
else
{
dvAlert.Visible = false;
btnSave.Visible = true;
//btnActivate.Visible = false;
//rcmbStatus.Visible = true;
PlaceHolderReactivate.Visible = false;
PlaceHolderActive.Visible = true;
}
}
public int SaveClientProfileDA(ClientBE objClientBE)
{
int rtnVal = 0;
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand("spSaveClientProfile", sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pClientName", objClientBE.ClientName));
sqlCmd.Parameters.Add(new MySqlParameter("pAddress1", objClientBE.Address1));
sqlCmd.Parameters.Add(new MySqlParameter("pAddress2", objClientBE.Address2));
sqlCmd.Parameters.Add(new MySqlParameter("pCity", objClientBE.City));
sqlCmd.Parameters.Add(new MySqlParameter("pState", objClientBE.State));
sqlCmd.Parameters.Add(new MySqlParameter("pCountryID", objClientBE.CountryID));
sqlCmd.Parameters.Add(new MySqlParameter("pPostCode", objClientBE.PostCode));
sqlCmd.Parameters.Add(new MySqlParameter("pPhone", objClientBE.Phone));
sqlCmd.Parameters.Add(new MySqlParameter("pWebsite", objClientBE.Website));
sqlCmd.Parameters.Add(new MySqlParameter("pIndustryID", objClientBE.IndustryID));
sqlCmd.Parameters.Add(new MySqlParameter("pAnnualRevID", objClientBE.AnnualRevID));
sqlCmd.Parameters.Add(new MySqlParameter("pNoOfUsers", objClientBE.NoOfUsers));
sqlCmd.Parameters.Add(new MySqlParameter("pClientStatus", objClientBE.ClientStatus));
sqlCmd.Parameters.Add(new MySqlParameter("pCurrentPkgSubscribed", objClientBE.CurrentPkgSubscribed));
sqlCmd.Parameters.Add(new MySqlParameter("pCreatedBy", objClientBE.CreatedBy));
sqlCmd.Parameters.Add(new MySqlParameter("pClientID", objClientBE.ClientID));
MySqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
rtnVal = Convert.ToInt32(reader[0]);
}
reader.Close();
reader = null;
return rtnVal;
}
}
catch (Exception ex)
{
throw;
}
}