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, "[]"))));
}
}
