protected void Page_Load(object sender, EventArgs e)
{
PageMenuID = Request.QueryString["ID"];
ObjAT_Cust = new M_AT_Mst_CustomerBO();
SetControlType();
if (!IsPostBack)
{
MaheshAF18.UIControlHelper.GenricControl.GetOperatorList(ddOperator);
MaheshAF18.UIControlHelper.GenricControl.GetFieldListByGrid(gvList, ddSearchBy);
FillDropdown();
InitializeControls();
RefreshGrid();
MultiView1.ActiveViewIndex = 0;
}
}
//SAVE
public static string CU_Mst_Customer(M_AT_Mst_CustomerBO mvObjCust)
{
M_AT_Mst_CustomerBO ObjAT_Cust = new M_AT_Mst_CustomerBO();
string strRetMst = "";
DataTable dt = new DataTable();
string var_ErrorMessage = "";
try
{
if (mvObjCust.MCust_RegType.Length == 0)
{
var_ErrorMessage = var_ErrorMessage + "Pls Select Customer Type<br>";
}
if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Customer", "M_Cust_ID", mvObjCust.M_Cust_ID, "MCustCode", mvObjCust.MCust_Code, ""))
{
var_ErrorMessage = var_ErrorMessage + "Customer Code Already Exist.<br>";
}
if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Customer", "M_Cust_ID", mvObjCust.M_Cust_ID, "MCust_Name", mvObjCust.MCust_Name, ""))
{
var_ErrorMessage = var_ErrorMessage + "Customer Name Already Exists.<br>";
}
if (mvObjCust.MCust_Code.Length == 0)
{
var_ErrorMessage = var_ErrorMessage + "Customer Code No Cannot Be Blank.<br>";
}
if (mvObjCust.MCust_Name.Length == 0)
{
var_ErrorMessage = var_ErrorMessage + "Customer Name Cannot Be Blank.<br>";
}
if (mvObjCust.MCust_TradeName.Length == 0)
{
var_ErrorMessage = var_ErrorMessage + "Customer Trade Name Cannot Be Blank.<br>";
}
if (mvObjCust.MCust_Reg_State_ID == 0)
{
var_ErrorMessage = var_ErrorMessage + "Select Customer State.<br>";
}
if (mvObjCust.MCust_ShippTo_State_ID == 0)
{
var_ErrorMessage = var_ErrorMessage + "Select Customer Shipp To State.<br>";
}
if (var_ErrorMessage.Length == 0)
{
using (TransactionScope scope = new TransactionScope())
{
if (Convert.ToInt32(mvObjCust.M_Cust_ID) == 0)
{
ObjAT_Cust.Fk_Company_ID = mvObjCust.Fk_Company_ID;
ObjAT_Cust.Fk_Branch_ID = mvObjCust.Fk_Branch_ID;
ObjAT_Cust.Fk_Year_ID = mvObjCust.Fk_Year_ID;
ObjAT_Cust.MDBSC_RowCreatedByUser_ID = mvObjCust.MDBSC_RowCreatedByUser_ID;
ObjAT_Cust.MDBSC_RowCreatedByUserName = mvObjCust.MDBSC_RowCreatedByUserName;
ObjAT_Cust.MCust_Code = MaheshAF18.Application.MEF.GenrateRefNo(mvObjCust.Fk_Company_ID, mvObjCust.Fk_Branch_ID, 0, "Customer", "CUST", "CUST", "No", "", "", "", 0);
}
ObjAT_Cust.M_Cust_ID = mvObjCust.M_Cust_ID;
ObjAT_Cust.MCust_Name = mvObjCust.MCust_Name;
ObjAT_Cust.MCust_TradeName = mvObjCust.MCust_TradeName;
ObjAT_Cust.MCust_RegType = mvObjCust.MCust_RegType;
ObjAT_Cust.MCust_CreditDays = mvObjCust.MCust_CreditDays;
ObjAT_Cust.MCust_Reg_Add1 = mvObjCust.MCust_Reg_Add1;
ObjAT_Cust.MCust_Reg_Add2 = mvObjCust.MCust_Reg_Add2;
ObjAT_Cust.MCust_Reg_Pincode = mvObjCust.MCust_Reg_Pincode;
ObjAT_Cust.MCust_Reg_City = mvObjCust.MCust_Reg_City;
ObjAT_Cust.MCust_Reg_State_ID = mvObjCust.MCust_Reg_State_ID;
ObjAT_Cust.MCust_Reg_Country = mvObjCust.MCust_Reg_Country;
ObjAT_Cust.MCust_BL_PANNO = mvObjCust.MCust_BL_PANNO;
ObjAT_Cust.MCust_BL_GSTNO = mvObjCust.MCust_BL_GSTNO;
ObjAT_Cust.MCust_Primary_Contact_Person = mvObjCust.MCust_Primary_Contact_Person;
ObjAT_Cust.MCust_Primary_CP_MobileNo = mvObjCust.MCust_Primary_CP_MobileNo;
ObjAT_Cust.MCust_Primary_CP_PhoneNo = mvObjCust.MCust_Primary_CP_PhoneNo;
ObjAT_Cust.MCust_Primary_CP_EmailID = mvObjCust.MCust_Primary_CP_EmailID;
ObjAT_Cust.MCust_ShippTo_CompanyName = mvObjCust.MCust_ShippTo_CompanyName;
ObjAT_Cust.MCust_ShippTo_ContactPerson = mvObjCust.MCust_ShippTo_ContactPerson;
ObjAT_Cust.MCust_ShippTo_CP_MobileNo = mvObjCust.MCust_ShippTo_CP_MobileNo;
ObjAT_Cust.MCust_ShippTo_Add1 = mvObjCust.MCust_ShippTo_Add1;
ObjAT_Cust.MCust_ShippTo_Add2 = mvObjCust.MCust_ShippTo_Add2;
ObjAT_Cust.MCust_ShippTo_Pincode = mvObjCust.MCust_ShippTo_Pincode;
ObjAT_Cust.MCust_ShippTo_City = mvObjCust.MCust_ShippTo_City;
ObjAT_Cust.MCust_ShippTo_State_ID = mvObjCust.MCust_ShippTo_State_ID;
ObjAT_Cust.MCust_ShippTo_Country = mvObjCust.MCust_ShippTo_Country;
ObjAT_Cust.MCust_ShippTo_PANNO = mvObjCust.MCust_ShippTo_PANNO;
ObjAT_Cust.MCust_ShippTo_GSTNO = mvObjCust.MCust_ShippTo_GSTNO;
ObjAT_Cust.MDBSC_RowStatus = mvObjCust.MDBSC_RowStatus;
ObjAT_Cust.MDBSC_RowLupdnByUser_ID = mvObjCust.MDBSC_RowLupdnByUser_ID;
ObjAT_Cust.MDBSC_RowLupdnUserName = mvObjCust.MDBSC_RowLupdnUserName;
ObjAT_Cust.MDBSC_RowLupdnOn_DT = DateHelper.ConvertToDataBase(DateHelper.ConvertToForm(DateTime.Now));
ObjAT_Cust.MCust_Contact_FaxNo = mvObjCust.MCust_Contact_FaxNo;
ObjAT_Cust.MCust_Contact_OfficeNo1 = mvObjCust.MCust_Contact_OfficeNo1;
ObjAT_Cust.MCust_Contact_OfficeNo2 = mvObjCust.MCust_Contact_OfficeNo2;
ObjAT_Cust.MCust_Contact_Email_Admin = mvObjCust.MCust_Contact_Email_Admin;
ObjAT_Cust.MCust_Contact_Website = mvObjCust.MCust_Contact_Website;
ObjAT_Cust.MCust_Primary_Contact_Designation = mvObjCust.MCust_Primary_Contact_Designation;
var_ErrorMessage = ObjAT_Cust.Insert_Update(ObjAT_Cust);
//ObjItem.MItem_ID =Convert.ToInt64( var_ErrorMessage.Substring((var_ErrorMessage.IndexOf("|") + 1), (var_ErrorMessage.Length - var_ErrorMessage.IndexOf("|") - 1)));
//var_ErrorMessage = var_ErrorMessage.Substring((0), (var_ErrorMessage.IndexOf("|")));
scope.Complete();
}
strRetMst = var_ErrorMessage;
}
else
{
strRetMst = var_ErrorMessage + "|" + mvObjCust.M_Cust_ID.ToString();
}
return(strRetMst);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public HttpResponseMessage CustomerMaster(M_AT_Mst_CustomerBO ObjCust)
{
ArrayList items = new ArrayList();
try
{
HttpResponseMessage RetResponse = new HttpResponseMessage();
string var_Company_ID = MaheshAF18.Application.CodeAssistance.GetHttpHeaderValue(Request, "CMPID", "0");
string var_Branch_ID = MaheshAF18.Application.CodeAssistance.GetHttpHeaderValue(Request, "BRID", "0");
string var_User_ID = MaheshAF18.Application.CodeAssistance.GetHttpHeaderValue(Request, "UserID", "0");
string var_User_Name = MaheshAF18.Application.CodeAssistance.GetHttpHeaderValue(Request, "UserName", "");
string var_ART = MaheshAF18.Application.CodeAssistance.GetHttpHeaderValue(Request, "ART", "");
string var_M_Cust_ID = MaheshAF18.Application.CodeAssistance.GetHttpHeaderValue(Request, "HDRID", "0");
string strSQLFilter = "";
strSQLFilter = " AND Fk_Company_ID=" + var_Company_ID + " AND Fk_Branch_ID=" + var_Branch_ID;
if (var_M_Cust_ID.Length > 0)
{
if (Convert.ToInt64(var_M_Cust_ID) > 0)
{
strSQLFilter = strSQLFilter + " AND M_Cust_ID=" + Convert.ToInt64(var_M_Cust_ID);
}
}
if (var_ART == "List")
{
items = AppMaster.Get_Mst_Customer_Lst(Convert.ToInt64(var_M_Cust_ID), strSQLFilter, "");
if ((items != null) || (items.Count > 0))
{
RetResponse = Request.CreateResponse(HttpStatusCode.OK, (new JsonRetMessage(false, true, "customer master get successfully", items)));
}
else
{
RetResponse = Request.CreateResponse(HttpStatusCode.OK, (new JsonRetMessage(false, true, "no records found", "[]")));
}
}
if (var_ART == "RCUD")
{
string varResMsg = "";
if (ObjCust != null)
{
ObjCust.Fk_Company_ID = Convert.ToInt64(var_Company_ID);
ObjCust.Fk_Branch_ID = Convert.ToInt64(var_Company_ID);
ObjCust.MDBSC_RowCreatedByUser_ID = Convert.ToInt16(var_User_ID);
ObjCust.MDBSC_RowCreatedByUserName = var_User_Name;
ObjCust.MDBSC_RowLupdnByUser_ID = Convert.ToInt16(var_User_ID);
ObjCust.MDBSC_RowLupdnUserName = var_User_Name;
//PropertyInfo[] properties =ObjCust.GetType().GetProperties();
//foreach (var property in properties)
//{
// if (property.PropertyType == typeof(string) && property.GetValue( != null)
// {
// string newvalue = GetUpdatedValue();
// property.SetValue(this, newvalue);
// }
//}
MPAL.ParseObject(ObjCust);
varResMsg = AppMaster.CU_Mst_Customer(ObjCust);
ObjCust.M_Cust_ID = Convert.ToInt64(varResMsg.Substring((varResMsg.IndexOf("|") + 1), (varResMsg.Length - varResMsg.IndexOf("|") - 1)));
varResMsg = varResMsg.Substring((0), (varResMsg.IndexOf("|")));
if (ObjCust.M_Cust_ID > 0)
{
items = AppMaster.Get_Mst_Customer_Lst(ObjCust.M_Cust_ID, strSQLFilter, "");
}
Boolean varRetStatus = false;
if ((varResMsg == "Added Successfully") || (varResMsg == "Updated Successfully"))
{
varRetStatus = true;
}
RetResponse = Request.CreateResponse(HttpStatusCode.OK, (new JsonRetMessage(false, varRetStatus, varResMsg, items)));
}
else
{
RetResponse = Request.CreateResponse(HttpStatusCode.OK, (new JsonRetMessage(false, false, "invalid item master object", "[]")));
}
}
return(RetResponse);
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.OK, (new JsonRetMessage(true, false, "internal server error " + Environment.NewLine + ex.Message, "[]"))));
}
}
