protected void Page_Load(object sender, EventArgs e) { PageMenuID = Request.QueryString["ID"]; ObjAT_Ven = new M_AT_Mst_VendorBO(); 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_Vendor(M_AT_Mst_VendorBO mvObjVen) { M_AT_Mst_VendorBO ObjAT_Ven = new M_AT_Mst_VendorBO(); string strRetMst = ""; DataTable dt = new DataTable(); string var_ErrorMessage = ""; try { if (mvObjVen.MVen_RegType.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Pls Select Vendor Type<br>"; } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Vendor", "M_Ven_ID", mvObjVen.M_Ven_ID, "MVenCode", mvObjVen.MVen_Code, "")) { var_ErrorMessage = var_ErrorMessage + "Vendor Code Already Exist.<br>"; } if (SQLManager.CheckDuplicateRecord("M_AT_Mst_Vendor", "M_Ven_ID", mvObjVen.M_Ven_ID, "MVen_Name", mvObjVen.MVen_Name, "")) { var_ErrorMessage = var_ErrorMessage + "Vendor Name Already Exists.<br>"; } if (mvObjVen.MVen_Code.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Vendor Code No Cannot Be Blank.<br>"; } if (mvObjVen.MVen_Name.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Vendor Name Cannot Be Blank.<br>"; } if (mvObjVen.MVen_TradeName.Length == 0) { var_ErrorMessage = var_ErrorMessage + "Vendor Trade Name Cannot Be Blank.<br>"; } if (mvObjVen.MVen_Reg_State_ID == 0) { var_ErrorMessage = var_ErrorMessage + "Select Customer State.<br>"; } if (mvObjVen.MVen_DispatchFrom_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(mvObjVen.M_Ven_ID) == 0) { ObjAT_Ven.Fk_Company_ID = mvObjVen.Fk_Company_ID; ObjAT_Ven.Fk_Branch_ID = mvObjVen.Fk_Branch_ID; ObjAT_Ven.Fk_Year_ID = mvObjVen.Fk_Year_ID; ObjAT_Ven.MDBSC_RowCreatedByUser_ID = mvObjVen.MDBSC_RowCreatedByUser_ID; ObjAT_Ven.MDBSC_RowCreatedByUserName = mvObjVen.MDBSC_RowCreatedByUserName; ObjAT_Ven.MVen_Code = MaheshAF18.Application.MEF.GenrateRefNo(mvObjVen.Fk_Company_ID, mvObjVen.Fk_Branch_ID, 0, "Vendor", "Ven", "Ven", "No", "", "", "", 0); } ObjAT_Ven.M_Ven_ID = mvObjVen.M_Ven_ID; ObjAT_Ven.MVen_Name = mvObjVen.MVen_Name; ObjAT_Ven.MVen_DisplayName = mvObjVen.MVen_DisplayName; ObjAT_Ven.MVen_TradeName = mvObjVen.MVen_TradeName; ObjAT_Ven.MVen_RegType = mvObjVen.MVen_RegType; ObjAT_Ven.MVen_CreditDays = mvObjVen.MVen_CreditDays; ObjAT_Ven.MVen_Reg_Add1 = mvObjVen.MVen_Reg_Add1; ObjAT_Ven.MVen_Reg_Add2 = mvObjVen.MVen_Reg_Add2; ObjAT_Ven.MVen_Reg_Pincode = mvObjVen.MVen_Reg_Pincode; ObjAT_Ven.MVen_Reg_City = mvObjVen.MVen_Reg_City; ObjAT_Ven.MVen_Reg_State_ID = mvObjVen.MVen_Reg_State_ID; ObjAT_Ven.MVen_Reg_Country = mvObjVen.MVen_Reg_Country; ObjAT_Ven.MVen_BL_PANNO = mvObjVen.MVen_BL_PANNO; ObjAT_Ven.MVen_BL_GSTNO = mvObjVen.MVen_BL_GSTNO; ObjAT_Ven.MVen_Primary_Contact_Person = mvObjVen.MVen_Primary_Contact_Person; ObjAT_Ven.MVen_Primary_CP_MobileNo = mvObjVen.MVen_Primary_CP_MobileNo; ObjAT_Ven.MVen_Primary_CP_PhoneNo = mvObjVen.MVen_Primary_CP_PhoneNo; ObjAT_Ven.MVen_Primary_CP_EmailID = mvObjVen.MVen_Primary_CP_EmailID; ObjAT_Ven.MVen_DispatchFrom_CompanyName = mvObjVen.MVen_DispatchFrom_CompanyName; ObjAT_Ven.MVen_DispatchFrom_ContactPerson = mvObjVen.MVen_DispatchFrom_ContactPerson; ObjAT_Ven.MVen_DispatchFrom_CP_MobileNo = mvObjVen.MVen_DispatchFrom_CP_MobileNo; ObjAT_Ven.MVen_DispatchFrom_Add1 = mvObjVen.MVen_DispatchFrom_Add1; ObjAT_Ven.MVen_DispatchFrom_Add2 = mvObjVen.MVen_DispatchFrom_Add2; ObjAT_Ven.MVen_DispatchFrom_Pincode = mvObjVen.MVen_DispatchFrom_Pincode; ObjAT_Ven.MVen_DispatchFrom_City = mvObjVen.MVen_DispatchFrom_City; ObjAT_Ven.MVen_DispatchFrom_State_ID = mvObjVen.MVen_DispatchFrom_State_ID; ObjAT_Ven.MVen_DispatchFrom_Country = mvObjVen.MVen_DispatchFrom_Country; ObjAT_Ven.MVen_DispatchFrom_PANNO = mvObjVen.MVen_DispatchFrom_PANNO; ObjAT_Ven.MVen_DispatchFrom_GSTNO = mvObjVen.MVen_DispatchFrom_GSTNO; ObjAT_Ven.MDBSC_RowStatus = mvObjVen.MDBSC_RowStatus; ObjAT_Ven.MDBSC_RowLupdnByUser_ID = mvObjVen.MDBSC_RowLupdnByUser_ID; ObjAT_Ven.MDBSC_RowLupdnUserName = mvObjVen.MDBSC_RowLupdnUserName; ObjAT_Ven.MDBSC_RowLupdnOn_DT = DateHelper.ConvertToDataBase(DateHelper.ConvertToForm(DateTime.Now)); ObjAT_Ven.MVen_Contact_FaxNo = mvObjVen.MVen_Contact_FaxNo; ObjAT_Ven.MVen_Contact_OfficeNo1 = mvObjVen.MVen_Contact_OfficeNo1; ObjAT_Ven.MVen_Contact_OfficeNo2 = mvObjVen.MVen_Contact_OfficeNo2; ObjAT_Ven.MVen_Contact_Email_Admin = mvObjVen.MVen_Contact_Email_Admin; ObjAT_Ven.MVen_Contact_Website = mvObjVen.MVen_Contact_Website; ObjAT_Ven.MVen_Primary_Contact_Designation = mvObjVen.MVen_Primary_Contact_Designation; var_ErrorMessage = ObjAT_Ven.Insert_Update(ObjAT_Ven); //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 + "|" + mvObjVen.M_Ven_ID.ToString(); } return(strRetMst); } catch (Exception ex) { throw new Exception(ex.Message); } }
public HttpResponseMessage VendorMaster(M_AT_Mst_VendorBO ObjVen) { 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_Ven_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_Ven_ID.Length > 0) { if (Convert.ToInt64(var_M_Ven_ID) > 0) { strSQLFilter = strSQLFilter + " AND M_Ven_ID=" + Convert.ToInt64(var_M_Ven_ID); } } if (var_ART == "List") { items = AppMaster.Get_Mst_Vendor_Lst(Convert.ToInt64(var_M_Ven_ID), strSQLFilter, ""); if ((items != null) || (items.Count > 0)) { RetResponse = Request.CreateResponse(HttpStatusCode.OK, (new JsonRetMessage(false, true, "Vendor master get successfully", items))); } else { RetResponse = Request.CreateResponse(HttpStatusCode.OK, (new JsonRetMessage(false, true, "no records found", "[]"))); } } if (var_ART == "RCUD") { string varResMsg = ""; if (ObjVen != null) { ObjVen.Fk_Company_ID = Convert.ToInt64(var_Company_ID); ObjVen.Fk_Branch_ID = Convert.ToInt64(var_Company_ID); ObjVen.MDBSC_RowCreatedByUser_ID = Convert.ToInt16(var_User_ID); ObjVen.MDBSC_RowCreatedByUserName = var_User_Name; ObjVen.MDBSC_RowLupdnByUser_ID = Convert.ToInt16(var_User_ID); ObjVen.MDBSC_RowLupdnUserName = var_User_Name; MPAL.ParseObject(ObjVen); varResMsg = AppMaster.CU_Mst_Vendor(ObjVen); ObjVen.M_Ven_ID = Convert.ToInt64(varResMsg.Substring((varResMsg.IndexOf("|") + 1), (varResMsg.Length - varResMsg.IndexOf("|") - 1))); varResMsg = varResMsg.Substring((0), (varResMsg.IndexOf("|"))); if (ObjVen.M_Ven_ID > 0) { items = AppMaster.Get_Mst_Vendor_Lst(ObjVen.M_Ven_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 vebdor object", "[]"))); } } return(RetResponse); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.OK, (new JsonRetMessage(true, false, "internal server error " + Environment.NewLine + ex.Message, "[]")))); } }