//Get
public ActionResult Client(int? clientID)
{
BindLookups();
BLClientSite clientBL = new BLClientSite();
tblClientSite editclient = new tblClientSite();
editclient = clientBL.GetClientSite(clientID.Value);
if (Request.IsAjaxRequest())
return PartialView(editclient);
else
return View(editclient);
}
public ActionResult Client(tblClientSite clientSite)
{
try
{
BLClientSite clientBL = new BLClientSite();
clientSite.CustomerID = SessionHelper.UserSession.CustomerID;
clientBL.SaveClientSite(clientSite);
}
catch
{
ModelState.AddModelError("", "Please provide valid User Name/Password.");
return Json(new { errors = KeyValue.GetErrorsFromModelState(ViewData) });
}
return Json(new { success = true });
}
/// Get All Client Site - CustomerID
///
public List<tblClientSite> GetAllClientSite(int CustomerID, int pageNumber, int pageSize, int sortColumnIndex, string sortOrder, string searchText, ref int totalRecords)
{
List<tblClientSite> lstClientSite = new List<tblClientSite>();
int errorNum = 0;
string errorDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@CustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, CustomerID);
DataAccess.addSqlParam("@pageNumber", ParameterDirection.Input, 16, MySqlDbType.Int32, pageNumber);
DataAccess.addSqlParam("@pageRecord", ParameterDirection.Input, 16, MySqlDbType.Int32, pageSize);
DataAccess.addSqlParam("@sortColumnIndex", ParameterDirection.Input, 16, MySqlDbType.Int32, sortColumnIndex);
DataAccess.addSqlParam("@searchOrder", ParameterDirection.Input, 4, MySqlDbType.VarChar, sortOrder);
DataAccess.addSqlParam("@searchText", ParameterDirection.Input, 100, MySqlDbType.VarChar, searchText);
DataSet ds = DataAccess.ExecuteDataSet(GET_ALL_CLIENT_SITE, ref errorNum, ref errorDesc);
tblClientSite Clientsite = new tblClientSite();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dtClientsite = ds.Tables[0];
DataTable dtTotalRecords = ds.Tables[1];
totalRecords = Common.ConvertToInt(dtTotalRecords.Rows[0], "TotalRecords");
if (dtClientsite != null && dtClientsite.Rows.Count > 0)
{
foreach (DataRow dr in dtClientsite.Rows)
{
Clientsite = new tblClientSite();
Clientsite.ClientID = Common.ConvertToInt(dr, "ClientID");
Clientsite.CustomerID = Common.ConvertToInt(dr, "CustomerID");
Clientsite.IsActive = Common.ConvertToInt(dr, "Isactive");
Clientsite.BusinessName = Common.ConvertToString(dr, "BusinessName");
Clientsite.ServiceType = new ServiceType();
Clientsite.ServiceType.ID = Common.ConvertToInt(dr, "ServiceType");
Clientsite.ServiceType.Name = LookUpValue.GetServiceType(Clientsite.ServiceType.ID.Value);
Clientsite.Status = new SetUpStaus();
Clientsite.Status.ID = Common.ConvertToInt(dr, "Status");
Clientsite.Status.Name = LookUpValue.GetSetUpStaus(Clientsite.Status.ID.Value);
Clientsite.TimeZone = new TimeZoneFX();
Clientsite.TimeZone.ID = Common.ConvertToInt(dr, "TimeZone");
Clientsite.TimeZone.Name = LookUpValue.GetTimeZone(Clientsite.TimeZone.ID.Value);
lstClientSite.Add(Clientsite);
}
}
}
return lstClientSite;
}
public int SaveClientSite(tblClientSite clientSite)
{
int errorNum = 0;
string errorDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@oClientID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSite.ClientID);
DataAccess.addSqlParam("@CustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSite.CustomerID);
DataAccess.addSqlParam("@BusinessName", ParameterDirection.Input, 100, MySqlDbType.VarChar, clientSite.BusinessName);
DataAccess.addSqlParam("@ServiceType", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSite.ServiceType.ID);
DataAccess.addSqlParam("@ClientStatus", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSite.Status.ID);
DataAccess.addSqlParam("@TimeZone", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSite.TimeZone.ID);
DataAccess.addSqlParam("@Isactive", ParameterDirection.Input, 16, MySqlDbType.Int16,1);
DataAccess.addSqlParam("@Identity", ParameterDirection.InputOutput, 16, MySqlDbType.Int32);
DataAccess.ExecuteNonQuery(SET_CLIENT_SITE, ref errorNum, ref errorDesc);
return Common.ConvertToInt(DataAccess.getSQLParam("@Identity").ToString());
}
public List<tblClientSite> GetCustomerClient(int CustomerID)
{
List<tblClientSite> lstClientSite = new List<tblClientSite>();
int errorNum = 0;
string errorDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@CustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, CustomerID);
DataSet ds = DataAccess.ExecuteDataSet(Get_CustomerClient, ref errorNum, ref errorDesc);
tblClientSite Clientsite = new tblClientSite();
if (ds != null && ds.Tables.Count > 0)
{
DataTable dtClientsite = ds.Tables[0];
if (dtClientsite != null && dtClientsite.Rows.Count > 0)
{
foreach (DataRow dr in dtClientsite.Rows)
{
Clientsite = new tblClientSite();
Clientsite.ClientID = Common.ConvertToInt(dr, "ClientID");
Clientsite.CustomerID = Common.ConvertToInt(dr, "CustomerID");
Clientsite.BusinessName = Common.ConvertToString(dr, "BusinessName");
Clientsite.ServiceType = new ServiceType();
Clientsite.ServiceType.ID = Common.ConvertToInt(dr, "ServiceType");
Clientsite.ServiceType.Name = LookUpValue.GetServiceType(Clientsite.ServiceType.ID.Value);
Clientsite.Status = new SetUpStaus();
Clientsite.Status.ID = Common.ConvertToInt(dr, "Status");
Clientsite.Status.Name = LookUpValue.GetSetUpStaus(Clientsite.Status.ID.Value);
Clientsite.TimeZone = new TimeZoneFX();
Clientsite.TimeZone.ID = Common.ConvertToInt(dr, "TimeZone");
Clientsite.TimeZone.Name = LookUpValue.GetTimeZone(Clientsite.TimeZone.ID.Value);
lstClientSite.Add(Clientsite);
}
}
}
return lstClientSite;
}
/// <summary>
/// Use Ciient ID in this function
/// </summary>
/// <param name="CustomerID"></param>
/// <returns></returns>
public tblClientSite GetClientSite(int ClientID)
{
int errorNum = 0;
string errorDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@ClientID", ParameterDirection.Input, 16, MySqlDbType.Int32, ClientID);
DataSet ds = DataAccess.ExecuteDataSet(GET_CLIENT_SITE, ref errorNum, ref errorDesc);
tblClientSite Clientsite = new tblClientSite();
if (ds != null && ds.Tables.Count > 0)
{
DataTable dtClientsite = ds.Tables[0];
if (dtClientsite != null && dtClientsite.Rows.Count > 0)
{
DataRow dr = dtClientsite.Rows[0];
Clientsite.ClientID = Common.ConvertToInt(dr, "ClientID");
Clientsite.CustomerID = Common.ConvertToInt(dr, "CustomerID");
Clientsite.IsActive = Common.ConvertToInt(dr, "Isactive");
Clientsite.BusinessName = Common.ConvertToString(dr, "BusinessName");
Clientsite.ServiceType = new ServiceType();
Clientsite.ServiceType.ID = Common.ConvertToInt(dr, "ServiceType");
Clientsite.ServiceType.Name = LookUpValue.GetServiceType(Clientsite.ServiceType.ID.Value);
Clientsite.Status = new SetUpStaus();
Clientsite.Status.ID = Common.ConvertToInt(dr, "Status");
Clientsite.Status.Name = LookUpValue.GetSetUpStaus(Clientsite.Status.ID.Value);
Clientsite.TimeZone = new TimeZoneFX();
Clientsite.TimeZone.ID = Common.ConvertToInt(dr, "TimeZone");
Clientsite.TimeZone.Name = LookUpValue.GetTimeZone(Clientsite.TimeZone.ID.Value);
}
}
return Clientsite;
}
//Get
public JsonResult JsonClient(int? ClientID)
{
BLClientSite clientBL = new BLClientSite();
tblClientSite editclient = new tblClientSite();
editclient = clientBL.GetClientSite(ClientID.Value);
return Json(new { success = true, ClientTimeZone = editclient.TimeZone == null ? "" : editclient.TimeZone.Name, ClientStatus = editclient.Status == null ? "" : editclient.Status.Name }, JsonRequestBehavior.AllowGet);
}
//Get
public ActionResult Index()
{
BLClientSite clientSiteBL = new BLClientSite();
List<tblClientSite> lstClientSite = new List<tblClientSite>();
lstClientSite.Add(new tblClientSite() { ClientID = 0, BusinessName = " -- Select -- " });
lstClientSite.AddRange(clientSiteBL.GetCustomerClient(SessionHelper.UserSession.CustomerID));
ViewBag.CustomerClientSites = lstClientSite;
tblClientSite clientSite = new tblClientSite();
clientSite.TimeZone = new TimeZoneFX();
clientSite.Status = new SetUpStaus();
if (Request.IsAjaxRequest())
return PartialView(clientSite);
else
return View(clientSite);
}