//Vendor DCN
public static DataTable Get_Ven_DCN_List(Int64 DCNVHDR_ID, string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
if (DCNVHDR_ID == 0)
{
strSqlString = "SELECT * FROM v_M_AT_DNC_Ven_AHDR" + strWhereClause +
" AND Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND Fk_Branch_ID=" + ObjSession.Company.BranchID + StrFilterCriteria + " ORDER BY DCNVHDR_ID desc ";
}
else
{
strSqlString = "SELECT * FROM v_M_AT_DNC_Ven_AHDR " +
" Where Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND Fk_Branch_ID=" + ObjSession.Company.BranchID + " AND DCNVHDR_ID=0" + DCNVHDR_ID;
}
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//Purchase
public static DataTable Get_DT_Purchase_Common_List(string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
strSqlString = " select PINV_TrnType RecType,PINV_Type TrnType,SINVHDR_ID TrnHDR_ID, " +
" Fk_Company_ID,Fk_Branch_ID,Fk_Year_ID,PINV_No TrnNo,vPINV_DT TrnDT,'Customer' PartyType, Fk_CustomerID PartyID, " +
" MCust_Name PartyName,PINV_DTL_CNT NoOFDtl,PINV_HDR_Total_Gross_Amt TrnTotalAmt " +
" FROM v_M_AT_Purchase_Inv_AHDR " +
strWhereClause + StrFilterCriteria +
" UNION ALL " +
" select 'DNCN' RecType,DCNV_Type TrnType,DCNCHDR_ID TrnHDR_ID, " +
" Fk_Company_ID,Fk_Branch_ID,Fk_Year_ID,DCNV_No TrnNo,vDCNV_DT TrnDT,'Customer' PartyType, 0 PartyID, " +
" MCust_Name PartyName,DCNV_DTL_CNT NoOFDtl,DCNV_HDR_Total_Gross_Amt TrnTotalAmt " +
" FROM v_M_AT_DNC_Ven_AHDR " +
strWhereClause + StrFilterCriteria;
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static DataTable Get_Mst_Vendor(Int64 M_Ven_ID, string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
if (M_Ven_ID == 0)
{
strSqlString = "SELECT * FROM v_M_AT_Mst_Vendor" + strWhereClause +
" AND Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND Fk_Branch_ID=" + ObjSession.Company.BranchID +
StrFilterCriteria + " Order By MVen_Name asc";
}
else
{
strSqlString = " SELECT * FROM v_M_AT_Mst_Vendor " +
" Where Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND Fk_Branch_ID=" + ObjSession.Company.BranchID + " AND M_Ven_ID=0" + M_Ven_ID;
}
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static DataTable Get_VenPayment_Inv_List(Int64 AVPHDR_ID, Int64 AVPDTL_ID, string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
strSqlString = " SELECT AVPDTL_ID,Fk_AVPHDRID,Fk_InvoiceID,PINV_No,vPINV_DT,Inv_Adjusted_Amt,PINV_HDR_Total_Gross_Amt,PINV_HDR_Paid_AsOn_Amt,PINV_HDR_Outstanding_AsOn_Amt " +
" FROM v_M_AT_Acc_Payment_Vendor_BDTL " +
" WHERE Fk_AVPHDRID=" + AVPHDR_ID +
" UNION ALL " +
" SELECT 0 AVPDTL_ID," + AVPHDR_ID + " Fk_AVPHDRID,PINVHDR_ID,PINV_No,vPINV_DT,0 Inv_Adjusted_Amt,PINV_HDR_Total_Gross_Amt,PINV_HDR_Paid_AsOn_Amt,PINV_HDR_Outstanding_AsOn_Amt " +
" FROM v_M_AT_Purchase_Inv_AHDR " +
" Where Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND Fk_Branch_ID=" + ObjSession.Company.BranchID +
" AND Fk_VendorID IN (SELECT Fk_VendorID FROM M_AT_Acc_Payment_Vendor_AHDR WHERE AVPHDR_ID=" + AVPHDR_ID + " ) " +
" AND PINVHDR_ID NOT IN (SELECT Fk_InvoiceID FROM M_AT_Acc_Payment_Vendor_BDTL WHERE Fk_AVPHDRID=" + AVPHDR_ID + " ) " +
" ORDER BY Fk_InvoiceID desc ";
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static DataTable Get_Mst_UOM(Int64 UOM_ID, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
if (UOM_ID == 0)
{
strSqlString = "SELECT * FROM v_M_AT_Mst_UOM" + strWhereClause + " Order By v_UOM_DisplayName ASC";
}
else
{
strSqlString = "SELECT * FROM v_M_AT_Mst_UOM " +
" Where UOM_ID=0" + UOM_ID;
}
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//Eway Bill
public static DataTable Get_EwayBill_List(Int64 SEWB_HDR_ID, string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
if (SEWB_HDR_ID == 0)
{
strSqlString = "SELECT * FROM v_M_AT_Sales_SEWB_AHDR" + strWhereClause +
" ORDER BY SEWB_HDR_ID desc ";
}
else
{
strSqlString = "SELECT * FROM v_M_AT_Sales_SEWB_AHDR " + strWhereClause +
" AND SEWB_HDR_ID=0" + SEWB_HDR_ID;
}
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static DataTable Rpt_Get_Acc_Receivable_Detail(string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
strSqlString = " SELECT AA.Fk_CustomerID, AA.MCust_Code, AA.MCust_Name,SINV_No,vSINV_DT,SINV_HDR_Total_Gross_Amt, " +
" SUM(CASE WHEN DATEDIFF( d,AA.SINV_DT,Getdate() ) BETWEEN 0 AND 30 THEN AA.SINV_HDR_Outstanding_AsOn_Amt ELSE 0 END) ThirtyDays, " +
" SUM(CASE WHEN DATEDIFF( d,AA.SINV_DT,Getdate() ) BETWEEN 31 AND 60 THEN AA.SINV_HDR_Outstanding_AsOn_Amt ELSE 0 END) SixtyDays, " +
" SUM(CASE WHEN DATEDIFF( d,AA.SINV_DT,Getdate() ) BETWEEN 61 AND 90 THEN AA.SINV_HDR_Outstanding_AsOn_Amt ELSE 0 END) NintyDays, " +
" SUM(CASE WHEN DATEDIFF( d,AA.SINV_DT,Getdate() ) > 91 THEN AA.SINV_HDR_Outstanding_AsOn_Amt ELSE 0 END) AboveNintyDays " +
" FROM v_M_AT_Sales_Inv_AHDR AA " + strWhereClause +
" AND AA.Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND AA.Fk_Branch_ID=" + ObjSession.Company.BranchID +
" AND AA.MDBSC_RowStatus='' " +
" AND AA.SINV_HDR_Outstanding_AsOn_Amt >0 " +
StrFilterCriteria +
" GROUP BY AA.Fk_CustomerID, AA.MCust_Code, AA.MCust_Name,SINV_No,vSINV_DT,SINV_HDR_Total_Gross_Amt ";
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//HSNSAC
public static DataTable Get_HSNSAC_Item(Int64 CHID_ID, string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
if (CHID_ID == 0)
{
strSqlString = "SELECT * FROM v_M_AT_Mst_CMP_HSNSAC" + strWhereClause + StrFilterCriteria +
" AND Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND Fk_Branch_ID=" + ObjSession.Company.BranchID + " Order By HSNCode ASC";
}
else
{
strSqlString = "SELECT * FROM v_M_AT_Mst_CMP_HSNSAC " + StrFilterCriteria +
" Where Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND Fk_Branch_ID=" + ObjSession.Company.BranchID + " AND CHID_ID=0" + CHID_ID;
}
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable List(Int64 M_RT_CMP_ID, string SearchCriteria)
{
string strSqlString = "";
try
{
MaheshAF18.WebSession.SessionPageLocal ObjSessionData = new MaheshAF18.WebSession.SessionPageLocal();
strSqlString = "SELECT * FROM v_AAA_M_RT_CMP_Info Where M_RT_CMP_ID=0" + ObjSessionData.Company.CompanyID;
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static DataTable Get_Excel_File_Column_List(Int64 GSTIN, string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
strSqlString = "SELECT * FROM v_M_AT_Upload_File_BDTL" + strWhereClause + StrFilterCriteria + " ORDER BY FUDTL_ID asc ";
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static void USP_Update_Tbl_Payment_Customer(Int64 CPHDRID)
{
string strSqlString = "";
try
{
MaheshAF18.WebSession.SessionPageLocal ObjSessionData = new MaheshAF18.WebSession.SessionPageLocal();
strSqlString = " AAA_M_USP_Update_Tbl_Payment_Customer " +
ObjSessionData.Company.CompanyID + "," +
ObjSessionData.Company.BranchID + "," +
ObjSessionData.Company.YearID + "," + CPHDRID + ",0";
MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//SALES DC
public static DataTable Rpt_Get_Sales_DC_Summary(string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
strSqlString = "SELECT * FROM v_M_AT_Sales_DC_AHDR" + strWhereClause +
" AND Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND Fk_Branch_ID=" + ObjSession.Company.BranchID + StrFilterCriteria + " ORDER BY DCHDR_ID desc ";
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static DataTable Rpt_Get_Purchase_Detail(string StrFilterCriteria, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
MaheshAF18.WebSession.SessionPageLocal ObjSession = new MaheshAF18.WebSession.SessionPageLocal();
strSqlString = " SELECT * FROM v_M_AT_Purchase_Inv_BDTL" + strWhereClause +
" AND Fk_Company_ID=" + ObjSession.Company.CompanyID +
" AND Fk_Branch_ID=" + ObjSession.Company.BranchID + StrFilterCriteria +
" ORDER BY PINVDTL_ID ASC";
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static DataTable Get_App_Branch_List(Int64 M_RT_CMP_BR_ID, string SearchCriteria)
{
string strWhereClause = "";
string strSqlString = "";
try
{
MaheshAF18.WebSession.SessionPageLocal ObjSessionData = new MaheshAF18.WebSession.SessionPageLocal();
strWhereClause = MaheshAF18.Application.MEF.GetSearchWhereClause(SearchCriteria);
string varStrCond = "";
// varStrCond = " AND M_RT_CMP_BR_ID IN (1) ";
if (varStrCond.Length > 0)
{
if (M_RT_CMP_BR_ID == 0)
{
strSqlString = "SELECT * FROM v_AAA_M_RT_CMP_Branch" + strWhereClause + " AND FK_M_RT_CMP_ID=" + ObjSessionData.Company.CompanyID + varStrCond;
}
else
{
strSqlString = "SELECT * FROM v_AAA_M_RT_CMP_Branch Where M_RT_CMP_BR_ID=0" + M_RT_CMP_BR_ID + varStrCond;
}
}
else
{
strSqlString = "SELECT * FROM v_AAA_M_RT_CMP_Branch Where FK_M_RT_CMP_ID=" + ObjSessionData.Company.CompanyID + " AND M_RT_CMP_BR_ID=0" + M_RT_CMP_BR_ID + varStrCond;
}
return(MaheshAF18.Application.MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
Session.Clear();
HttpRequest request = HttpContext.Current.Request;
string strErrorMessage = "";
if (IsValid)
{
if (string.IsNullOrEmpty(userid.Text))
{
strErrorMessage = strErrorMessage + "Invalid User ID \n\n";
}
if (string.IsNullOrEmpty(Password.Text))
{
strErrorMessage = strErrorMessage + "Invalid Password \n\n";
}
if (strErrorMessage.Length == 0)
{
MaheshAF18.WebSession.SessionPageLocal ObjSessionData = new MaheshAF18.WebSession.SessionPageLocal();
ObjSessionData = MaheshAF18.Application.MEF.ProjectSession_AppUser(userid.Text, Password.Text, "", "", "", "", "");
if ((ObjSessionData.UserData.LoginStatus == true) && (ObjSessionData.Company.YearID == 1) &&
(ObjSessionData.Company.CompanyID == 1)
)
{
if (ObjSessionData.UserData.TypeDesc == "SA")
{
MaheshAF18.Application.MEF.ProjectSession_Company(SessionUserData.UserData.UserID.ToString(),
SessionUserData.UserData.LoginID.ToString(),
SessionUserData.UserData.UserCompanyID, 0, 0, "");
MaheshAF18.Application.MEF.ProjectSession_Company(SessionUserData.UserData.UserID.ToString(),
SessionUserData.UserData.LoginID.ToString(),
SessionUserData.UserData.UserCompanyID, SessionUserData.UserData.UserBranchID, 0, "");
MaheshAF18.Application.MEF.ProjectSession_AppModule(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, SessionUserData.Company.YearID,
0, SessionUserData.UserData.TypeID, SessionUserData.UserData.RoleID, SessionUserData.UserData.UserID, "SA");
Response.Redirect(SessionUserData.AppInfo.DefaultRedirect, false);
}
if (ObjSessionData.UserData.TypeDesc == "TG")
{
MaheshAF18.Application.MEF.ProjectSession_Company(SessionUserData.UserData.UserID.ToString(),
SessionUserData.UserData.LoginID.ToString(),
SessionUserData.UserData.UserCompanyID, 0, 0, "");
MaheshAF18.Application.MEF.ProjectSession_Company(SessionUserData.UserData.UserID.ToString(),
SessionUserData.UserData.LoginID.ToString(),
SessionUserData.UserData.UserCompanyID, SessionUserData.UserData.UserBranchID, 0, "");
MaheshAF18.Application.MEF.ProjectSession_AppModule(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, SessionUserData.Company.YearID,
0, SessionUserData.UserData.TypeID, SessionUserData.UserData.RoleID, SessionUserData.UserData.UserID, "TG");
Response.Redirect(SessionUserData.AppInfo.DefaultRedirect);
}
if (ObjSessionData.UserData.TypeDesc == "WAU")
{
MaheshAF18.Application.MEF.ProjectSession_Company(SessionUserData.UserData.UserID.ToString(),
SessionUserData.UserData.LoginID.ToString(),
SessionUserData.UserData.UserCompanyID, 0, 0, "");
MaheshAF18.Application.MEF.ProjectSession_Company(SessionUserData.UserData.UserID.ToString(),
SessionUserData.UserData.LoginID.ToString(),
SessionUserData.UserData.UserCompanyID, SessionUserData.UserData.UserBranchID, 0, "");
MaheshAF18.Application.MEF.ProjectSession_AppModule(SessionUserData.Company.CompanyID, SessionUserData.Company.BranchID, SessionUserData.Company.YearID,
0, SessionUserData.UserData.TypeID, SessionUserData.UserData.RoleID, SessionUserData.UserData.UserID, "WAU");
Response.Redirect(SessionUserData.AppInfo.DefaultRedirect, false);
}
}
else
{
strErrorMessage = "Invalid Username/Password ";
}
}
else
{
strErrorMessage = "Invalid Username/Password ";
}
}
DisplayCustomMessageSummary(strErrorMessage);
}
catch
{
DisplayCustomMessageSummary("Invalid Username/Password ");
}
}
