public static string DeleteRegion(string ITEMID, string UserID, string BranchID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter ITEMID_P = new SqlParameter("@ITEMID", ITEMID);
SqlParameter DeleteBy_P = new SqlParameter("@DeleteBy", UserID);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
msg = AACommon.Execute("ITM_ITEM_DELETE", Conn, ITEMID_P, DeleteBy_P, Branch);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string UpdateRegion(string ITEMID, string ITEMName, string ItemCode, string BarCode, string Discription, string UnitTypeID, string Category, string Brand, string BranchID, string PurchasePrice, string SalePrice)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter ITEMID_P = new SqlParameter("@ITEMID", ITEMID);
SqlParameter ITEMName_P = new SqlParameter("@ITEMName", ITEMName);
SqlParameter ItemCode_P = new SqlParameter("@ItemCode", ItemCode);
SqlParameter BarCode_P = new SqlParameter("@BarCode", BarCode);
SqlParameter Discription_P = new SqlParameter("@Discription", Discription);
SqlParameter UnitTypeID_P = new SqlParameter("@UnitTypeID", UnitTypeID);
SqlParameter CatID = new SqlParameter("@CatID", Category);
SqlParameter BrandID = new SqlParameter("@BrandID", Brand);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
SqlParameter PPrice = new SqlParameter("@PurchasePrice", PurchasePrice);
SqlParameter SPrice = new SqlParameter("@SalePrice", SalePrice);
msg = AACommon.Execute("ITM_ITEM_UPDATE", Conn, ITEMID_P, ITEMName_P, ItemCode_P, BarCode_P, Discription_P, UnitTypeID_P, CatID, BrandID, Branch, PPrice, SPrice);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string UpdateRegion(string UnitID, string UnitTitle, string DisplayName, string UnitTypeID, string IsBase, string BaseMultiplier)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter UnitID_P = new SqlParameter("@UnitID", UnitID);
SqlParameter UnitTitle_P = new SqlParameter("@UnitTitle", UnitTitle);
SqlParameter DisplayName_P = new SqlParameter("@DisplayName", DisplayName);
SqlParameter UnitTypeID_P = new SqlParameter("@UnitTypeID", UnitTypeID);
SqlParameter IsBase_P = new SqlParameter("@IsBase", IsBase);
SqlParameter BaseMultiplier_P = new SqlParameter("@BaseMultiplier", BaseMultiplier);
msg = AACommon.Execute("ITM_UNIT_Update", Conn, UnitID_P, UnitTitle_P, DisplayName_P, UnitTypeID_P, IsBase_P, BaseMultiplier_P);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string UpdateRegion(string DistrictID, string utid, string form, string UserID, string BranchID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter UTFID = new SqlParameter("@UTFID", DistrictID);
SqlParameter FormID = new SqlParameter("@FormID", form);
SqlParameter UTID = new SqlParameter("@UTID", utid);
SqlParameter MODIFYBY = new SqlParameter("@MODIFYBY", UserID);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
msg = AACommon.Execute("USERTYPE_FORM_UPDATE", Conn, UTFID, FormID, UTID, MODIFYBY, Branch);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string DeleteRegion(string DistrictID, string UserID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
//SqlParameter DISTRICT_ID_1 = new SqlParameter("@DISTRICT_ID", DistrictID);
//DataSet ds = AACommon.ReturnDatasetBySP("TALUKA_CHECK_FOR_DELETE_DISTRICT", Conn, DISTRICT_ID_1);
//if (ds.Tables[0].Rows.Count > 0)
//{ retMessage = "false"; return retMessage; }
//else
//{
SqlParameter DISTRICT_ID = new SqlParameter("@FormID", DistrictID);
SqlParameter MODIFYBY = new SqlParameter("@MODIFYBY", UserID);
msg = AACommon.Execute("FORM_DELETE", Conn, DISTRICT_ID, MODIFYBY);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
//}
}
public static string InsertRegion(string UnitTitle, string DisplayName, string UnitTypeID, string IsBase, string BaseMultiplier, string UserID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
string ID = AACommon.GetAlphaNumericIDSIX("ITM_UNIT", "UN-", "UnitID", Conn);
SqlParameter UnitID_P = new SqlParameter("@UnitID", ID);
SqlParameter UnitTypeDesc_P = new SqlParameter("@UnitTitle", UnitTitle);
SqlParameter DisplayName_P = new SqlParameter("@DisplayName", DisplayName);
SqlParameter UnitTypeID_P = new SqlParameter("@UnitTypeID", UnitTypeID);
SqlParameter IsBase_P = new SqlParameter("@IsBase", IsBase);
SqlParameter BaseMultiplier_P = new SqlParameter("@BaseMultiplier", BaseMultiplier);
SqlParameter CREATEBY = new SqlParameter("@CreateBy", UserID);
msg = AACommon.Execute("ITM_UNIT_Insert", Conn, UnitID_P, UnitTypeDesc_P, DisplayName_P, UnitTypeID_P, IsBase_P, BaseMultiplier_P, CREATEBY);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string InsertRegion(string AreaTitle, string TalukaID, string UserID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
string ID = AACommon.GetAlphaNumericIDSIX("Area", "AR-", "AreaID", Conn);
SqlParameter UnitID_P = new SqlParameter("@AreaID", ID);
SqlParameter UnitTypeDesc_P = new SqlParameter("@AreaTitle", AreaTitle);
SqlParameter UnitTypeID_P = new SqlParameter("@TalukaID", TalukaID);
SqlParameter CREATEBY = new SqlParameter("@CreateBy", UserID);
msg = AACommon.Execute("SP_Area_Insert", Conn, UnitID_P, UnitTypeDesc_P, UnitTypeID_P, CREATEBY);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string UpdateRegion(string DistrictID, string DistrictName, string pid, string path, string UserID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter FormID = new SqlParameter("@FormID", DistrictID);
SqlParameter FormTitle = new SqlParameter("@FormTitle", DistrictName);
SqlParameter PID = new SqlParameter("@PID", pid);
SqlParameter PATH = new SqlParameter("@Path", path);
SqlParameter MODIFYBY = new SqlParameter("@MODIFYBY", UserID);
msg = AACommon.Execute("FORM_UPDATE", Conn, FormID, FormTitle, PID, PATH, MODIFYBY);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string UpdateRegion(string DistrictID, string DistrictName, string LoginIDString, string PasswordString, string EmailString, string PhoneString, string ManagerIDString, string UTIDString, string UUserID, string BranchID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
PasswordString = Encryption.Encrypt(PasswordString);
SqlParameter UserID = new SqlParameter("@UserID", DistrictID);
SqlParameter UserName = new SqlParameter("@UserName", DistrictName);
SqlParameter loginID = new SqlParameter("@loginID", LoginIDString);
SqlParameter Password = new SqlParameter("@Password", PasswordString);
SqlParameter email = new SqlParameter("@email", EmailString);
SqlParameter Phone = new SqlParameter("@Phone", PhoneString);
SqlParameter ManagerID = new SqlParameter("@ManagerID", ManagerIDString);
SqlParameter UTID = new SqlParameter("@UTID", UTIDString);
SqlParameter MODIFYBY = new SqlParameter("@MODIFYBY", UUserID);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
msg = AACommon.Execute("USER_UPDATE_2", Conn, UserID, UserName, loginID, Password, email, Phone, ManagerID, UTID, MODIFYBY, Branch);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string DeleteRegion(string DistrictID, string UUserID, string BranchID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter UserID_1 = new SqlParameter("@UserID", DistrictID);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
DataSet ds = AACommon.ReturnDatasetBySP("USER_CHECK_FOR_DELETE_MANAGER", Conn, UserID_1, Branch);
if (ds.Tables[0].Rows.Count > 0)
{
retMessage = "false"; return(retMessage);
}
else
{
SqlParameter UserID = new SqlParameter("@UserID", DistrictID);
SqlParameter MODIFYBY = new SqlParameter("@MODIFYBY", UUserID);
SqlParameter BranchP = new SqlParameter("@BranchID", BranchID);
msg = AACommon.Execute("USER_DELETE", Conn, UserID, MODIFYBY, BranchP);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
}
public static string UpdateRegion(string ITEMID, string ITEMName, string ItemCode, string BarCode, string Discription, string UnitTypeID, string DistPerc, string TradePrice, string RetailPrice, string PackingTypeID, string txtWt)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter ITEMID_P = new SqlParameter("@ITEMID", ITEMID);
SqlParameter ITEMName_P = new SqlParameter("@ITEMName", ITEMName);
SqlParameter ItemCode_P = new SqlParameter("@ItemCode", ItemCode);
SqlParameter BarCode_P = new SqlParameter("@BarCode", BarCode);
SqlParameter Discription_P = new SqlParameter("@Discription", Discription);
SqlParameter UnitTypeID_P = new SqlParameter("@UnitTypeID", UnitTypeID);
SqlParameter DistPercentage_P = new SqlParameter("@DistPercentage", DistPerc);
SqlParameter TradePrice_P = new SqlParameter("@TradePrice", TradePrice);
SqlParameter RetailPrice_P = new SqlParameter("@RetailPrice", RetailPrice);
SqlParameter PackingTypeID_P = new SqlParameter("@PackingTypeID", PackingTypeID);
SqlParameter Wt = new SqlParameter("@Wt", txtWt);
msg = AACommon.Execute("ITM_ITEM_UPDATE_V2", Conn, ITEMID_P, ITEMName_P, ItemCode_P, BarCode_P, Discription_P, UnitTypeID_P, DistPercentage_P, TradePrice_P, RetailPrice_P, PackingTypeID_P, Wt);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string UpdateRegion(string CustomerID, string CustomerTitle, string CustomerCode, string Phone, string Fax, string Email, string AddressLine1, string AddressLine2, string NTN, string GST, string SRB, string InvDays, string AgDays, string opBal)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter CustomerID_P = new SqlParameter("@CustomerID", CustomerID);
SqlParameter CustomerTitle_P = new SqlParameter("@CustomerTitle", CustomerTitle);
SqlParameter CustomerCode_P = new SqlParameter("@CustomerCode", CustomerCode);
SqlParameter Phone_P = new SqlParameter("@Phone", Phone);
SqlParameter Fax_P = new SqlParameter("@Fax", Fax);
SqlParameter Email_P = new SqlParameter("@Email", Email);
SqlParameter AddressLine1_P = new SqlParameter("@AddressLine1", AddressLine1);
SqlParameter AddressLine2_P = new SqlParameter("@AddressLine2", AddressLine2);
SqlParameter NTN_P = new SqlParameter("@NTN", NTN);
SqlParameter GST_P = new SqlParameter("@GST", GST);
SqlParameter SRB_P = new SqlParameter("@SRB", SRB);
SqlParameter InvoiceDays = new SqlParameter("@InvoiceDays", InvDays);
SqlParameter AgingDays = new SqlParameter("@AgingDays", AgDays);
SqlParameter OpBal = new SqlParameter("@OpBal", opBal);
msg = AACommon.Execute("Customer_Update", Conn, CustomerID_P, CustomerTitle_P, CustomerCode_P, Phone_P, Fax_P, Email_P, AddressLine1_P, AddressLine2_P, NTN_P, GST_P, SRB_P, InvoiceDays, AgingDays, OpBal);
//Update_Account_OpBal
SqlConnection ConACC = new SqlConnection(ConfigurationManager.ConnectionStrings["ConACC"].ConnectionString);
string lgrID = AACommon.GetData("select LedgerID from Customer where CustomerID='" + CustomerID + "'", Conn, "LedgerID");
string opD = "0"; string opC = "0";
if (Convert.ToDecimal(opBal) > 0)
{
opD = opBal; opC = "0";
}
else if (Convert.ToDecimal(opBal) < 0)
{
opD = "0"; opC = opBal;
}
SqlParameter L4_ID = new SqlParameter("@L4_ID", lgrID);
SqlParameter Opcr = new SqlParameter("@Opcr", opC);
SqlParameter Opdr = new SqlParameter("@Opdr", opD);
AACommon.Execute("Update_Account_OpBal", ConACC, L4_ID, Opcr, Opdr);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string InsertRegion(string ITEMName, string ItemCode, string BarCode, string Discription, string Loose, string LoosePrice, string Strip, string StripPrice, string Box, string BoxPrice, string Carton, string CartonPrice, string UserID, string UnitTypeID, string Category, string Brand, string BranchID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
string ID = AACommon.GetAlphaNumericIDSIX("ITM_ITEM", "ITM-", "ITEMID", Conn);
SqlParameter ITEMID_P = new SqlParameter("@ITEMID", ID);
SqlParameter ITEMName_P = new SqlParameter("@ITEMName", ITEMName);
SqlParameter ItemCode_P = new SqlParameter("@ItemCode", ItemCode);
SqlParameter BarCode_P = new SqlParameter("@BarCode", BarCode);
SqlParameter Discription_P = new SqlParameter("@Discription", Discription);
SqlParameter Loose_P = new SqlParameter("@Loose", Loose);
SqlParameter LoosePrice_P = new SqlParameter("@LoosePrice", LoosePrice);
SqlParameter Strip_P = new SqlParameter("@Strip", Strip);
SqlParameter StripPrice_P = new SqlParameter("@StripPrice", StripPrice);
SqlParameter Box_P = new SqlParameter("@Box", Box);
SqlParameter BoxPrice_P = new SqlParameter("@BoxPrice", BoxPrice);
SqlParameter Carton_P = new SqlParameter("@Carton", Carton);
SqlParameter CartonPrice_P = new SqlParameter("@CartonPrice", CartonPrice);
SqlParameter CREATEBY = new SqlParameter("@CreateBy", UserID);
SqlParameter IsSale_P = new SqlParameter("@IsSale", "1");
SqlParameter IsPurchase_P = new SqlParameter("@IsPurchase", "0");
SqlParameter UnitTypeID_P = new SqlParameter("@UnitTypeID", UnitTypeID);
SqlParameter CatID = new SqlParameter("@CatID", Category);
SqlParameter BrandID = new SqlParameter("@BrandID", Brand);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
//isale=1
//ispurchase=0
msg = AACommon.Execute("ITM_ITEM_INSERT", Conn, ITEMID_P, ITEMName_P, ItemCode_P, BarCode_P, Discription_P, Loose_P, LoosePrice_P, Strip_P, StripPrice_P, Box_P, BoxPrice_P, Carton_P, CartonPrice_P, CREATEBY, IsSale_P, IsPurchase_P, UnitTypeID_P, CatID, BrandID, Branch);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string InsertRegion(string ITEMName, string ItemCode, string BarCode, string Discription, string UserID, string UnitTypeID, string DistPerc, string TradePrice, string RetailPrice, string PackingTypeID, string txtWt)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
string ID = AACommon.GetAlphaNumericIDSIX("ITM_ITEM", "ITM-", "ITEMID", Conn);
SqlParameter ITEMID_P = new SqlParameter("@ITEMID", ID);
SqlParameter ITEMName_P = new SqlParameter("@ITEMName", ITEMName);
SqlParameter ItemCode_P = new SqlParameter("@ItemCode", ItemCode);
SqlParameter BarCode_P = new SqlParameter("@BarCode", BarCode);
SqlParameter Discription_P = new SqlParameter("@Discription", Discription);
SqlParameter CREATEBY = new SqlParameter("@CreateBy", UserID);
SqlParameter IsSale_P = new SqlParameter("@IsSale", "1");
SqlParameter IsPurchase_P = new SqlParameter("@IsPurchase", "1");
SqlParameter UnitTypeID_P = new SqlParameter("@UnitTypeID", UnitTypeID);
SqlParameter DistPercentage_P = new SqlParameter("@DistPercentage", DistPerc);
SqlParameter TradePrice_P = new SqlParameter("@TradePrice", TradePrice);
SqlParameter RetailPrice_P = new SqlParameter("@RetailPrice", RetailPrice);
SqlParameter PackingTypeID_P = new SqlParameter("@PackingTypeID", PackingTypeID);
SqlParameter Wt = new SqlParameter("@Wt", txtWt);
//isale=1
//ispurchase=0
msg = AACommon.Execute("ITM_ITEM_INSERT_V2", Conn, ITEMID_P, ITEMName_P, ItemCode_P, BarCode_P, Discription_P, CREATEBY, IsSale_P, IsPurchase_P, UnitTypeID_P, DistPercentage_P, TradePrice_P, RetailPrice_P, PackingTypeID_P, Wt);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string UpdateRegion(string DeedID, string DeedTitle)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter DistrictID_P = new SqlParameter("@DeedID", DeedID);
SqlParameter DistrictTitle_P = new SqlParameter("@DeedTitle", DeedTitle);
msg = AACommon.Execute("SP_Deed_Update", Conn, DistrictID_P, DistrictTitle_P);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string UpdateRegion(string UnitTypeID, string UnitTypeDesc)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter UnitTypeID_P = new SqlParameter("@UnitTypeID", UnitTypeID);
SqlParameter UnitTypeDesc_P = new SqlParameter("@UnitTypeDesc", UnitTypeDesc);
msg = AACommon.Execute("ITM_UNIT_TYPE_Update", Conn, UnitTypeID_P, UnitTypeDesc_P);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string InsertRegion(string RegionName, string UserID, string BranchID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter UTDesc = new SqlParameter("@UTDesc", RegionName);
SqlParameter CREATEBY = new SqlParameter("@CREATEBY", UserID);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
msg = AACommon.Execute("USERTYPE_INSERT", Conn, UTDesc, CREATEBY, Branch);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string UpdateRegion(string AreaID, string AreaTitle, string TalukaID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter UnitID_P = new SqlParameter("@AreaID", AreaID);
SqlParameter UnitTitle_P = new SqlParameter("@AreaTitle", AreaTitle);
SqlParameter UnitTypeID_P = new SqlParameter("@TalukaID", TalukaID);
msg = AACommon.Execute("SP_Area_Update", Conn, UnitID_P, UnitTitle_P, UnitTypeID_P);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string DeleteRegion(string AreaID, string UserID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter UnitID_P = new SqlParameter("@AreaID", AreaID);
SqlParameter DeleteBy_P = new SqlParameter("@DeleteBy", UserID);
msg = AACommon.Execute("SP_Area_Delete", Conn, UnitID_P, DeleteBy_P);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string InsertRegion(string DeedTitle, string UserID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
string ID = AACommon.GetAlphaNumericIDSIX("Deed", "DEED-", "DeedID", Conn);
SqlParameter DistrictID_P = new SqlParameter("@DeedID", ID);
SqlParameter DistrictTitle_P = new SqlParameter("@DeedTitle", DeedTitle);
SqlParameter CREATEBY = new SqlParameter("@CreateBy", UserID);
msg = AACommon.Execute("SP_Deed_Insert", Conn, DistrictID_P, DistrictTitle_P, CREATEBY);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string InsertRegion(string Packing, string UserID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
string ID = AACommon.GetAlphaNumericIDSIX("ITEM_Packing", "PACK-", "PackingTypeID", Conn);
SqlParameter PackingTypeID_P = new SqlParameter("@PackingTypeID", ID);
SqlParameter PackingTypeDesc_P = new SqlParameter("@PackingTypeDesc", Packing);
SqlParameter CREATEBY = new SqlParameter("@CreateBy", UserID);
msg = AACommon.Execute("ITEM_Packing_Insert", Conn, PackingTypeID_P, PackingTypeDesc_P, CREATEBY);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string InsertRegion(string DistrictName, string LoginIDString, string PasswordString, string EmailString, string PhoneString, string ManagerIDString, string UTIDString, string image, string UUserID, string BranchID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
string ID = AACommon.GetAlphaNumericIDSIX("USERS", "USR-", "UserID", Conn);
string ImageID = ID;
//string Pic_Path = HttpContext.Current.Server.MapPath("~/Images/UserImages/");
//string fileNameWitPath = Pic_Path + ImageID + ".jpg";
//using (FileStream fs = new FileStream(Pic_Path, FileMode.Create))
//{
// using (BinaryWriter bw = new BinaryWriter(fs))
// {
// byte[] data = Convert.FromBase64String(image);
// bw.Write(data);
// bw.Close();
// }
//}
string path = HttpContext.Current.Server.MapPath("~/Images/UserImages/");
string fileNameWitPath = path + ImageID + ".jpg";
ImageID = ImageID + ".jpg";
if (image != "No Image")
{
using (FileStream fs = new FileStream(fileNameWitPath, FileMode.Create))
{
using (BinaryWriter bw = new BinaryWriter(fs))
{
byte[] data = Convert.FromBase64String(image);
bw.Write(data);
bw.Close();
}
}
}
else
{
image = "/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCABaAFoDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD7YooooAKKKms7S5v7mOztIzJNKwVFHc/0HvQBDVqz0vUtQOLGwnn944yR+fSvSdA8B6XpiJNfxpd3XUlhmNT/ALKn+ZrplVUUKqgAdAOgoA8euvCWuWFo99fW8VvEgyfMmUHPoADyfaseva9b0Sy16zNnfKxUHejKcMjeo/PvXlPiHw9e+HroQ3WHicZhmUYDj09j6igDKooooAKKKKACiiigArtPhhbxvqV5cMoLRQqF9txOf5CuLrvPhaP3mot/sxD9WoA7+iiigArC8bWsV14bvfMUEwx+ah/usp6/zH41u1keK/8AkXNS/wCvZ/5UAeN0UUUAFFFFABRRRQAV6P8ADOwSLTZ9RWZma4fy2QjhdmcY+ua84r0D4Y6lGYLrSGyJFf7QnoVOAfyIH50Ad3RRRQAVT1ex/tLTLmxMvlCeJkL7c7c98d6uVm+IdSi0nR7q8lJ+WMqgHUueFH50AeLdCeeneigcKB6CigAooooAKKKKACtnwlqsOka9b3Vy22FsxSHsA3GT9Disakb7p+lAHvYIYAg5Bpap6PF5Ok2cJBylvGD/AN8irlABXBfE3VoytvosTZfPny47DooP6n8BXeHpXkHjZs+KL8A9GQYz/sLQBiUUUUAFFFFABRSEgDJNa+keFta1rD2dpthP/LaX5U/DufwoAya6b4faV/aGufaJoFkgtELNvXI3Hhf6n8K6bSfhxpdptk1ORr2Qclfuxj8ByfxNdVBbW9rEsNtAkUa9FRQAPwFAEnA4FLRRQAVwvxN00fZ7bVooV/dsY5mA5w33SfoQR+Nd1TWVXBV1BBGCCM5FAHg3vRXrGreA9B1LdJFbmzmPO+DgZ916GuM1fwDrembpLZVvoRzmIYcD3X/DNAHNUUrKyMUdSrA4IIwR+FJQB6h4f8A6bpgS51FVvLoc/MMxofZe/wBTXVBQMYGMdKB0paACiiigAooooAKKKKACkxmlooAydZ8M6Pri/wCmWoEuMCZPlkH49/oc1yD/AAuv97eXq8GzJ27ojnHbPPWvRaKAP//Z";
using (FileStream fs = new FileStream(fileNameWitPath, FileMode.Create))
{
using (BinaryWriter bw = new BinaryWriter(fs))
{
byte[] data = Convert.FromBase64String(image);
bw.Write(data);
bw.Close();
}
}
}
PasswordString = Encryption.Encrypt(PasswordString);
SqlParameter UserID = new SqlParameter("@UserID", ID);
SqlParameter UserName = new SqlParameter("@UserName", DistrictName);
SqlParameter loginID = new SqlParameter("@loginID", LoginIDString);
SqlParameter Password = new SqlParameter("@Password", PasswordString);
SqlParameter email = new SqlParameter("@email", EmailString);
SqlParameter Phone = new SqlParameter("@Phone", PhoneString);
SqlParameter Picture = new SqlParameter("@Picture", ImageID);
SqlParameter ManagerID = new SqlParameter("@ManagerID", ManagerIDString);
SqlParameter UTID = new SqlParameter("@UTID", UTIDString);
SqlParameter CREATEBY = new SqlParameter("@CREATEBY", UUserID);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
msg = AACommon.Execute("USER_INSERT", Conn, UserID, UserName, loginID, Password, email, Phone, Picture, ManagerID, UTID, CREATEBY, Branch);
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string InsertRegion(string CustomerTitle, string CustomerCode, string Phone, string Fax, string Email, string AddressLine1, string AddressLine2, string NTN, string GST, string SRB, string UserID, string InvDays, string AgDays, string opBal, string txtCellNo, string txtPhone2, string txtCNIC, string ddlBookingDay, string ddlDeliveryDay, string ddlCustomerTypeID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlConnection ConACC = new SqlConnection(ConfigurationManager.ConnectionStrings["ConACC"].ConnectionString);
string ID = AACommon.GetAlphaNumericIDSIX("Customer", "CUS-", "CustomerID", Conn);
SqlParameter CustomerID_P = new SqlParameter("@CustomerID", ID);
SqlParameter CustomerTitle_P = new SqlParameter("@CustomerTitle", CustomerTitle);
SqlParameter CustomerCode_P = new SqlParameter("@CustomerCode", CustomerCode);
SqlParameter Phone_P = new SqlParameter("@Phone", Phone);
SqlParameter Fax_P = new SqlParameter("@Fax", Fax);
SqlParameter Email_P = new SqlParameter("@Email", Email);
SqlParameter AddressLine1_P = new SqlParameter("@AddressLine1", AddressLine1);
SqlParameter AddressLine2_P = new SqlParameter("@AddressLine2", AddressLine2);
SqlParameter NTN_P = new SqlParameter("@NTN", NTN);
SqlParameter GST_P = new SqlParameter("@GST", GST);
SqlParameter SRB_P = new SqlParameter("@SRB", SRB);
SqlParameter InvoiceDays = new SqlParameter("@InvoiceDays", InvDays);
SqlParameter AgingDays = new SqlParameter("@AgingDays", AgDays);
SqlParameter OpBal = new SqlParameter("@OpBal", opBal);
SqlParameter CREATEBY = new SqlParameter("@CreateBy", UserID);
SqlParameter CellNo = new SqlParameter("@CellNo", txtCellNo);
SqlParameter Phone2 = new SqlParameter("@Phone2", txtPhone2);
SqlParameter CNIC = new SqlParameter("@CNIC", txtCNIC);
SqlParameter BookingDay = new SqlParameter("@BookingDay", ddlBookingDay);
SqlParameter DeliveryDay = new SqlParameter("@DeliveryDay", ddlDeliveryDay);
SqlParameter CustomerTypeID = new SqlParameter("@CustomerTypeID", ddlCustomerTypeID);
msg = AACommon.Execute("Customer_InsertV2", Conn, CustomerID_P, CustomerTitle_P, CustomerCode_P, Phone_P, Fax_P, Email_P, AddressLine1_P, AddressLine2_P, NTN_P, GST_P, SRB_P, InvoiceDays, AgingDays, OpBal, CREATEBY, CellNo, Phone2, CNIC, BookingDay, DeliveryDay, CustomerTypeID);
//Changes by SA //
/////////////////////ACCOUNTS /////////////////////////
string opD = "0"; string opC = "0";
if (Convert.ToDecimal(opBal) > 0)
{
opD = opBal; opC = "0";
}
else if (Convert.ToDecimal(opBal) < 0)
{
opD = "0"; opC = opBal;
}
string L4ID = AACommon.GetData("SELECT AccountID FROM AACCOUNTS_Integration WHERE (Description = 'Accounts Receivable')", ConACC, "AccountID");
string ledgerID = AACommon.GetAlphaNumericIDTHREE("Accounts", L4ID, "L4_ID", ConACC);
SqlParameter L4_ID = new SqlParameter("@L4_ID", ledgerID);
SqlParameter Desc_Level4 = new SqlParameter("@Desc_Level4", CustomerTitle);
SqlParameter L4_IDNew = new SqlParameter("@L4_IDNew", L4ID);
SqlParameter Opdr = new SqlParameter("@Opdr", opD);
SqlParameter Opcr = new SqlParameter("@Opcr", opC);
SqlParameter CompanyID = new SqlParameter("@CompanyID", "12");
SqlParameter FiscalID = new SqlParameter("@FiscalID", "22");
SqlParameter BalanceValidation = new SqlParameter("@BalanceValidation", "0");
AACommon.Execute("Insert_Accounts", ConACC, L4_ID, Desc_Level4, L4_IDNew, Opdr, Opcr, CompanyID, FiscalID, BalanceValidation);
/////////////////////////////////////
string str = "update Customer set LedgerID='" + ledgerID + "' where CustomerID='" + ID + "'";
SqlCommand cmd = new SqlCommand(str, Conn);
if (Conn.State == ConnectionState.Closed)
{
Conn.Open();
}
cmd.ExecuteNonQuery();
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
//Changes by SA //
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string SaveTransaction(string UserID, string str, string txtVDate, string txtVoucherNo, string txtTotAmount, string txtDiscount, string txtTaxRate, string txtTotTax, string txtGrandTotal, string ddlSupplier, string txtTotAmountRMB, string RMBValueHDN, string txtDiscountPKR, string txtDiscountRMB, string txtCusAmountPKR, string txtCusAmountRMB, string ddlShop, string txtCustomerName, string txtContactNo, string txtAddress, string txtBillNo, string BranchID, string RcvdAccount, string RcvdPKR, string RcvdRMB, string txtCashBack, string txtCashRcvd, string X5000, string X1000, string X500, string X100, string X50, string X20, string X10, string X5, string X2, string X1)
{
string msg = "";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlCommand cmdMasterDelete = new SqlCommand("delete from SP_MASTER where SPID='" + txtVoucherNo + "'", Con);
Con.Open();
cmdMasterDelete.ExecuteNonQuery();
Con.Close();
SqlCommand cmdDetailDelete = new SqlCommand("delete from SP_DETAIL where SPID='" + txtVoucherNo + "'", Con);
Con.Open();
cmdDetailDelete.ExecuteNonQuery();
Con.Close();
SqlCommand cmdTransactionMasterDelete = new SqlCommand("delete from tbl_transaction where TaskID='" + txtVoucherNo + "'", Con);
Con.Open();
cmdTransactionMasterDelete.ExecuteNonQuery();
Con.Close();
SqlCommand cmdTransactionDetailDelete = new SqlCommand("delete from Transaction_Detail where TaskID='" + txtVoucherNo + "'", Con);
Con.Open();
cmdTransactionDetailDelete.ExecuteNonQuery();
Con.Close();
SqlCommand cmdTransactionMasterDeletePayment = new SqlCommand("delete from tbl_transaction where TaskID='C-" + txtVoucherNo + "'", Con);
Con.Open();
cmdTransactionMasterDeletePayment.ExecuteNonQuery();
Con.Close();
SqlCommand cmdTransactionDetailDeletePayment = new SqlCommand("delete from Transaction_Detail where TaskID='C-" + txtVoucherNo + "'", Con);
Con.Open();
cmdTransactionDetailDeletePayment.ExecuteNonQuery();
Con.Close();
string rqID = "";
string rqHID = "";
string rqDt = "";
string rqBy = UserID;
string rqAt = "";
string stsID = "";// 0:Pending, 1:Approved, 2:Rejected
///////////////////////// ID GNERATOR /////////////////////////////
string aa = LoadNUMBER("SO", "SP_MASTER", "SPID", Con, BranchID);
string[] idDT = aa.Split('`');
rqID = idDT[0].ToString();
rqDt = idDT[1].ToString();
// rqHID = LoadHistoryID(rqID);
rqID = txtVoucherNo;
rqDt = txtVDate;
/////////////////////////// INSERT in SP MASTER //////////////////
SqlParameter SPID = new SqlParameter("@SPID", rqID);
SqlParameter SPDate = new SqlParameter("@SPDate", txtVDate);
SqlParameter TotalAmount = new SqlParameter("@TotalAmount", txtTotAmount);
SqlParameter DiscountAmount = new SqlParameter("@DiscountAmount", txtDiscount);
SqlParameter TaxAmount = new SqlParameter("@TaxAmount", txtTotTax);
SqlParameter TaxRate = new SqlParameter("@TaxRate", txtTaxRate);
SqlParameter GrandTotal = new SqlParameter("@GrandTotal", txtGrandTotal);
SqlParameter RMBAmount = new SqlParameter("@RMBAmount", txtTotAmountRMB);
SqlParameter AccountID = new SqlParameter("@AccountID", ddlSupplier);
SqlParameter SP = new SqlParameter("@SP", "S");
SqlParameter CarryAmountPKR = new SqlParameter("@CarryAmountPKR", "0");
SqlParameter CarryAmountRMB = new SqlParameter("@CarryAmountRMB", "0");
SqlParameter PackingAmountPKR = new SqlParameter("@PackingAmountPKR", "0");
SqlParameter PackingAmountRMB = new SqlParameter("@PackingAmountRMB", "0");
SqlParameter ExChargeAmountPKR = new SqlParameter("@ExChargeAmountPKR", "0");
SqlParameter ExChatgeAmountRMB = new SqlParameter("@ExChatgeAmountRMB", "0");
SqlParameter SupplierAmountPKR = new SqlParameter("@SupplierAmountPKR", "0");
SqlParameter SupplierAmountRMB = new SqlParameter("@SupplierAmountRMB", "0");
SqlParameter SalesDiscountPKR = new SqlParameter("@SalesDiscountPKR", txtDiscountPKR);
SqlParameter SalesDiscountRMB = new SqlParameter("@SalesDiscountRMB", txtDiscountRMB);
SqlParameter CusAmountPKR = new SqlParameter("@CusAmountPKR", txtCusAmountPKR);
SqlParameter CusAmountRMB = new SqlParameter("@CusAmountRMB", txtCusAmountRMB);
SqlParameter CarryID = new SqlParameter("@CarryID", "0");
SqlParameter ExChargesID = new SqlParameter("@ExChargesID", "0");
SqlParameter PackingID = new SqlParameter("@PackingID", "0");
SqlParameter ShopName = new SqlParameter("@ShopName", ddlShop);
SqlParameter CustomerName = new SqlParameter("@CustomerName", txtCustomerName);
SqlParameter CreateBy = new SqlParameter("@CreateBy", UserID);
SqlParameter CustomerContactNo = new SqlParameter("@CustomerContactNo", txtContactNo);
SqlParameter CustomerAddress = new SqlParameter("@CustomerAddress", txtAddress);
SqlParameter LocalBillNo = new SqlParameter("@LocalBillNo", txtBillNo);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
SqlParameter CashBack = new SqlParameter("@CashBack", txtCashBack);
SqlParameter CashRcvd = new SqlParameter("@CashRcvd", txtCashRcvd);
SqlParameter P5000 = new SqlParameter("@X5000", X5000);
SqlParameter P1000 = new SqlParameter("@X1000", X1000);
SqlParameter P500 = new SqlParameter("@X500", X500);
SqlParameter P100 = new SqlParameter("@X100", X100);
SqlParameter P50 = new SqlParameter("@X50", X50);
SqlParameter P20 = new SqlParameter("@X20", X20);
SqlParameter P10 = new SqlParameter("@X10", X10);
SqlParameter P5 = new SqlParameter("@X5", X5);
SqlParameter P2 = new SqlParameter("@X2", X2);
SqlParameter P1 = new SqlParameter("@X1", X1);
AACommon.Execute("SP_MASTER_INSERT_CASH_SALE", Con, SPID, SPDate, TotalAmount, DiscountAmount, TaxAmount, TaxRate, GrandTotal, RMBAmount, AccountID, SP, CarryAmountPKR, CarryAmountRMB, PackingAmountPKR, PackingAmountRMB, ExChargeAmountPKR, ExChatgeAmountRMB, SupplierAmountPKR, SupplierAmountRMB, SalesDiscountPKR, SalesDiscountRMB, CusAmountPKR, CusAmountRMB, CarryID, ExChargesID, PackingID, ShopName, CustomerName, CreateBy, CustomerContactNo, CustomerAddress, LocalBillNo, Branch, CashBack, CashRcvd, P5000, P1000, P500, P100, P50, P20, P10, P5, P2, P1);
/////////////////////// INSERT in SP DETAIL
string[] itmLST = str.Split('`');
for (int i = 0; i < itmLST.Length; i++)
{
string[] itmROW = itmLST[i].Split('^');
//txtAccID + "^" + txtAccTitle + "^" + ddlUnit + "^" + txtQty + "^" + txtPrice + "^" + txtTotalPrice
string itmID = itmROW[0].ToString();
string ddlUnit = itmROW[2].ToString();
string txtQty = itmROW[3].ToString();
string txtPrice = itmROW[4].ToString();
string txtTotalPrice = itmROW[5].ToString();
string txtUnitPriceRMB = itmROW[6].ToString();
string txtTotalPriceRMB = itmROW[7].ToString();
string txtRMBValue = itmROW[8].ToString();
string PRID = itmROW[9].ToString();
string PRDID = itmROW[10].ToString();
string txtSrNo = itmROW[11].ToString();
string BatchID = itmROW[12].ToString();
string OrgQty = itmROW[13].ToString();
string txtDescription = itmROW[14].ToString();
SqlParameter SPID_1 = new SqlParameter("@SPID", rqID);
SqlParameter ITEMID = new SqlParameter("@ITEMID", itmID);
SqlParameter UnitID = new SqlParameter("@UnitID", ddlUnit);
SqlParameter QtyIn = new SqlParameter("@QtyIn", txtQty);
SqlParameter UnitPrice = new SqlParameter("@UnitPrice", txtPrice);
SqlParameter TotalPrice = new SqlParameter("@TotalPrice", txtTotalPrice);
SqlParameter RMBValue = new SqlParameter("@RMBValue", txtRMBValue);
SqlParameter RMBUnitPrice = new SqlParameter("@RMBUnitPrice", txtUnitPriceRMB);
SqlParameter RMBTotalPrice = new SqlParameter("@RMBTotalPrice", txtTotalPriceRMB);
SqlParameter Type = new SqlParameter("@Type", "S");
SqlParameter BasicUnitPricePKR = new SqlParameter("@BasicUnitPricePKR", txtPrice);
SqlParameter BasicUnitPriceRMB = new SqlParameter("@BasicUnitPriceRMB", txtUnitPriceRMB);
SqlParameter SRNO = new SqlParameter("@SrNo", txtSrNo);
SqlParameter CreateByNew = new SqlParameter("@CreateBy", UserID);
SqlParameter BranchP = new SqlParameter("@BranchID", BranchID);
SqlParameter DescriptionP = new SqlParameter("@Description", txtDescription);
AACommon.Execute("SP_DETAIL_INSERT_2", Con, SPID_1, ITEMID, UnitID, QtyIn, UnitPrice, TotalPrice, RMBValue, RMBUnitPrice, RMBTotalPrice, Type, BasicUnitPricePKR, BasicUnitPriceRMB, SRNO, CreateByNew, BranchP, DescriptionP);
decimal qt = Convert.ToDecimal(OrgQty);
//SqlDataAdapter daAv = new SqlDataAdapter("select BatchID from SP_DETAIL where ID='"+BatchID+"'", Con);
//DataTable dtAv = new DataTable();
//daAv.Fill(dtAv);
//if (dtAv.Rows.Count > 0)
//{
SqlCommand cmdUPdateBatch = new SqlCommand("update SP_DETAIL Set QtyAvailed = QtyAvailed-" + qt + " where ID='" + BatchID + "' ", Con);
Con.Open();
cmdUPdateBatch.ExecuteNonQuery();
Con.Close();
//}
PRID = PRID.Replace(" Purchase # : ", "");
PRDID = PRDID.Replace(" ID : ", "");
SqlDataAdapter da = new SqlDataAdapter("select * from SP_DETAIL where SPID='" + PRID + "' and ITEMID='" + itmID + "' and ID='" + PRDID + "'", Con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
double AvailedQty = Convert.ToDouble(dt.Rows[0]["QtyAvailed"].ToString());
double Qty = Convert.ToDouble(txtQty);
AvailedQty = AvailedQty + Qty;
SqlCommand cmd = new SqlCommand("update SP_DETAIL set QtyAvailed='" + AvailedQty + "' where SPID='" + PRID + "' and ITEMID='" + itmID + "' and ID='" + PRDID + "'", Con);
Con.Open();
cmd.ExecuteNonQuery();
Con.Close();
SqlDataAdapter da1 = new SqlDataAdapter("select MAX(ID) from SP_DETAIL where SPID='" + rqID + "' and ITEMID='" + itmID + "'", Con);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
SqlCommand cmd1 = new SqlCommand("update SP_DETAIL set BatchID='" + PRDID + "' where ID='" + dt1.Rows[0][0].ToString() + "'", Con);
Con.Open();
cmd1.ExecuteNonQuery();
Con.Close();
}
}
}
////////////////////SAVE TRANSACTION IN ACCOUNTS ////////////////////
string FinalAmountPKR = "";
string FinalAmountRMB = "";
if (Convert.ToDouble(txtTotTax) > 0)
{
FinalAmountPKR = Convert.ToString(Convert.ToDouble(txtTotAmount) + Convert.ToDouble(txtTotTax));
FinalAmountRMB = Convert.ToString(Convert.ToDouble(txtTotAmountRMB) + Convert.ToDouble(txtTotTax));
}
string Narration = "Invoice By SO # " + rqID + "";
SqlCommand cmd2 = new SqlCommand("insert into tbl_transaction (Date,Narration,AmountPKR,AmountRMB,RMBValue,TaskID,CreateBy,BranchID) values ('" + txtVDate + "','" + Narration + "','" + FinalAmountPKR + "','" + FinalAmountRMB + "','" + RMBValueHDN + "','" + rqID + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmd2.ExecuteNonQuery();
Con.Close();
string SaleRevenuAccount = "";
string SaleDiscountAccount = "";
string SaleTaxAccount = "";
SqlDataAdapter daPurchase = new SqlDataAdapter("select AccountsID from Accounts where BranchID='" + BranchID + "' and AccountsTitle='Sales Revenue'", Con);
DataTable dtPurchase = new DataTable();
daPurchase.Fill(dtPurchase);
if (dtPurchase.Rows.Count > 0)
{
SaleRevenuAccount = dtPurchase.Rows[0][0].ToString();
}
SqlDataAdapter daDiscount = new SqlDataAdapter("select AccountsID from Accounts where BranchID='" + BranchID + "' and AccountsTitle='Sales Discount'", Con);
DataTable dtDiscount = new DataTable();
daDiscount.Fill(dtDiscount);
if (dtDiscount.Rows.Count > 0)
{
SaleDiscountAccount = dtDiscount.Rows[0][0].ToString();
}
SqlDataAdapter daTax = new SqlDataAdapter("select AccountsID from Accounts where BranchID='" + BranchID + "' and AccountsTitle='TAX Liability'", Con);
DataTable dtTax = new DataTable();
daTax.Fill(dtTax);
if (dtTax.Rows.Count > 0)
{
SaleTaxAccount = dtTax.Rows[0][0].ToString();
}
if (Convert.ToDouble(txtTotTax) > 0)
{
txtCusAmountPKR = Convert.ToString(Convert.ToDouble(txtCusAmountPKR) + Convert.ToDouble(txtTotTax));
txtCusAmountRMB = Convert.ToString(Convert.ToDouble(txtCusAmountRMB) + Convert.ToDouble(txtTotTax));
}
///PURCHASE ENTRY
SqlCommand cmdPurchase1 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + ddlSupplier + "','SALE','" + txtCusAmountPKR + "','" + txtCusAmountRMB + "','0','0','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase1.ExecuteNonQuery();
Con.Close();
if (Convert.ToDouble(txtDiscountPKR) > 0)
{
Narration = "Sales Discount By SO # " + rqID + "";
SqlCommand cmdPurchase3 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + SaleDiscountAccount + "','SALE','" + txtDiscountPKR + "','" + txtDiscountRMB + "','0','0','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase3.ExecuteNonQuery();
Con.Close();
}
if (Convert.ToDouble(txtTotTax) > 0)
{
Narration = "Sales Tax By SO # " + rqID + "";
SqlCommand cmdPurchase3 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + SaleTaxAccount + "','SALE','0','0','" + txtTotTax + "','" + txtTotTax + "','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase3.ExecuteNonQuery();
Con.Close();
}
Narration = "Invoice By SO # " + rqID + "";
SqlCommand cmdPurchase2 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + SaleRevenuAccount + "','SALE','0','0','" + txtTotAmount + "','" + txtTotAmountRMB + "','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase2.ExecuteNonQuery();
Con.Close();
///PURCHASE ENTRY
////////////////////SAVE TRANSACTION IN ACCOUNTS FOR CASH////////////////////
if (Convert.ToDouble(RcvdPKR) > 0)
{
string NarrationCash = "Payment Rcvd By CS # " + rqID + "";
SqlCommand cmd2Cash = new SqlCommand("insert into tbl_transaction (Date,Narration,AmountPKR,AmountRMB,RMBValue,TaskID,CreateBy,BranchID) values ('" + txtVDate + "','" + NarrationCash + "','" + RcvdPKR + "','" + RcvdRMB + "','" + RMBValueHDN + "','C-" + rqID + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmd2Cash.ExecuteNonQuery();
Con.Close();
///PURCHASE ENTRY
SqlCommand cmdPurchase1Cash = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + RcvdAccount + "','CASH-PVC','" + RcvdPKR + "','" + RcvdRMB + "','0','0','" + RMBValueHDN + "','C-" + rqID + "','" + NarrationCash + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase1Cash.ExecuteNonQuery();
Con.Close();
NarrationCash = "Payment Rcvd By CS # " + rqID + "";
SqlCommand cmdPurchase2Cash = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + ddlSupplier + "','CASH-PVC','0','0','" + RcvdPKR + "','" + RcvdRMB + "','" + RMBValueHDN + "','C-" + rqID + "','" + NarrationCash + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase2Cash.ExecuteNonQuery();
Con.Close();
}
return(msg + rqID);
}
public static string SaveTransaction(string UserID, string str, string txtVDate, string txtVoucherNo, string txtTotAmount, string txtDiscount, string txtTaxRate, string txtTotTax, string txtGrandTotal, string ddlSupplier, string txtTotAmountRMB, string RMBValueHDN, string txtSupplierPKR, string txtSupplierRMB, string txtDiscountPKR, string txtDiscountRMB, string BranchID, string txtAddress, string txtBillNo)
{
string msg = "";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlCommand cmdMasterDelete = new SqlCommand("delete from SP_MASTER where SPID='" + txtVoucherNo + "'", Con);
Con.Open();
cmdMasterDelete.ExecuteNonQuery();
Con.Close();
SqlCommand cmdDetailDelete = new SqlCommand("delete from SP_DETAIL where SPID='" + txtVoucherNo + "'", Con);
Con.Open();
cmdDetailDelete.ExecuteNonQuery();
Con.Close();
SqlCommand cmdTransactionMasterDelete = new SqlCommand("delete from tbl_transaction where TaskID='" + txtVoucherNo + "'", Con);
Con.Open();
cmdTransactionMasterDelete.ExecuteNonQuery();
Con.Close();
SqlCommand cmdTransactionDetailDelete = new SqlCommand("delete from Transaction_Detail where TaskID='" + txtVoucherNo + "'", Con);
Con.Open();
cmdTransactionDetailDelete.ExecuteNonQuery();
Con.Close();
string rqID = "";
string rqHID = "";
string rqDt = "";
string rqBy = UserID;
string rqAt = "";
string stsID = "";// 0:Pending, 1:Approved, 2:Rejected
///////////////////////// ID GNERATOR /////////////////////////////
string aa = LoadNUMBER("PR", "SP_MASTER", "SPID", Con, BranchID);
string[] idDT = aa.Split('`');
rqID = idDT[0].ToString();
rqDt = idDT[1].ToString();
// rqHID = LoadHistoryID(rqID);
rqID = txtVoucherNo;
rqDt = txtVDate;
/////////////////////////// INSERT in SP MASTER //////////////////
SqlParameter SPID = new SqlParameter("@SPID", rqID);
SqlParameter SPDate = new SqlParameter("@SPDate", txtVDate);
SqlParameter TotalAmount = new SqlParameter("@TotalAmount", txtTotAmount);
SqlParameter DiscountAmount = new SqlParameter("@DiscountAmount", txtDiscount);
SqlParameter TaxAmount = new SqlParameter("@TaxAmount", txtTotTax);
SqlParameter TaxRate = new SqlParameter("@TaxRate", txtTaxRate);
SqlParameter GrandTotal = new SqlParameter("@GrandTotal", txtGrandTotal);
SqlParameter RMBAmount = new SqlParameter("@RMBAmount", txtTotAmountRMB);
SqlParameter AccountID = new SqlParameter("@AccountID", ddlSupplier);
SqlParameter SP = new SqlParameter("@SP", "P");
SqlParameter CarryAmountPKR = new SqlParameter("@CarryAmountPKR", "0");
SqlParameter CarryAmountRMB = new SqlParameter("@CarryAmountRMB", "0");
SqlParameter PackingAmountPKR = new SqlParameter("@PackingAmountPKR", "0");
SqlParameter PackingAmountRMB = new SqlParameter("@PackingAmountRMB", "0");
SqlParameter ExChargeAmountPKR = new SqlParameter("@ExChargeAmountPKR", "0");
SqlParameter ExChatgeAmountRMB = new SqlParameter("@ExChatgeAmountRMB", "0");
SqlParameter SupplierAmountPKR = new SqlParameter("@SupplierAmountPKR", txtSupplierPKR);
SqlParameter SupplierAmountRMB = new SqlParameter("@SupplierAmountRMB", txtSupplierRMB);
SqlParameter SalesDiscountPKR = new SqlParameter("@SalesDiscountPKR", txtDiscountPKR);
SqlParameter SalesDiscountRMB = new SqlParameter("@SalesDiscountRMB", txtDiscountRMB);
SqlParameter CusAmountPKR = new SqlParameter("@CusAmountPKR", "0");
SqlParameter CusAmountRMB = new SqlParameter("@CusAmountRMB", "0");
SqlParameter CarryID = new SqlParameter("@CarryID", "0");
SqlParameter ExChargesID = new SqlParameter("@ExChargesID", "0");
SqlParameter PackingID = new SqlParameter("@PackingID", "0");
SqlParameter ShopName = new SqlParameter("@ShopName", "");
SqlParameter CustomerName = new SqlParameter("@CustomerName", "");
SqlParameter CreateBy = new SqlParameter("@CreateBy", UserID);
SqlParameter CustomerContactNo = new SqlParameter("@CustomerContactNo", "");
SqlParameter CustomerAddress = new SqlParameter("@CustomerAddress", txtAddress);
SqlParameter LocalBillNo = new SqlParameter("@LocalBillNo", txtBillNo);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
AACommon.Execute("SP_MASTER_INSERT", Con, SPID, SPDate, TotalAmount, DiscountAmount, TaxAmount, TaxRate, GrandTotal, RMBAmount, AccountID, SP, CarryAmountPKR, CarryAmountRMB, PackingAmountPKR, PackingAmountRMB, ExChargeAmountPKR, ExChatgeAmountRMB, SupplierAmountPKR, SupplierAmountRMB, SalesDiscountPKR, SalesDiscountRMB, CusAmountPKR, CusAmountRMB, CarryID, ExChargesID, PackingID, ShopName, CustomerName, CreateBy, CustomerContactNo, CustomerAddress, LocalBillNo, Branch);
/////////////////////// INSERT in SP DETAIL
string[] itmLST = str.Split('`');
for (int i = 0; i < itmLST.Length; i++)
{
string[] itmROW = itmLST[i].Split('^');
//txtAccID + "^" + txtAccTitle + "^" + ddlUnit + "^" + txtQty + "^" + txtPrice + "^" + txtTotalPrice
string itmID = itmROW[0].ToString();
//string ddlUnit = itmROW[2].ToString();
string txtQty = itmROW[2].ToString();
string txtPrice = itmROW[3].ToString();
string txtTotalPrice = itmROW[4].ToString();
string txtUnitPriceRMB = itmROW[5].ToString();
string txtTotalPriceRMB = itmROW[6].ToString();
string txtRMBValue = itmROW[7].ToString();
//string txtCarry = itmROW[8].ToString();
//string txtExtraCharges = itmROW[9].ToString();
//string txtPKRCost = itmROW[10].ToString();
//string txtRMBCost = itmROW[11].ToString();
//string txtPackingRate = itmROW[12].ToString();
//string txtPackingPrice = itmROW[13].ToString();
//string txtPackingPricePKR = itmROW[14].ToString();
string txtSrNo = itmROW[8].ToString();
string BatchID = itmROW[9].ToString();
string Balance = itmROW[10].ToString();
SqlParameter SPID_1 = new SqlParameter("@SPID", rqID);
SqlParameter ITEMID = new SqlParameter("@ITEMID", itmID);
SqlParameter UnitID = new SqlParameter("@UnitID", "UN-000050");
SqlParameter QtyIn = new SqlParameter("@QtyIn", txtQty);
SqlParameter UnitPrice = new SqlParameter("@UnitPrice", txtPrice);
SqlParameter TotalPrice = new SqlParameter("@TotalPrice", txtTotalPrice);
SqlParameter RMBValue = new SqlParameter("@RMBValue", txtRMBValue);
SqlParameter RMBUnitPrice = new SqlParameter("@RMBUnitPrice", txtUnitPriceRMB);
SqlParameter RMBTotalPrice = new SqlParameter("@RMBTotalPrice", txtTotalPriceRMB);
SqlParameter Type = new SqlParameter("@Type", "P");
SqlParameter Carry = new SqlParameter("@Carry", "0");
SqlParameter ExtraCharges = new SqlParameter("@ExtraCharges", "0");
SqlParameter BasicUnitPricePKR = new SqlParameter("@BasicUnitPricePKR", txtPrice);
SqlParameter BasicUnitPriceRMB = new SqlParameter("@BasicUnitPriceRMB", txtUnitPriceRMB);
SqlParameter RMBPackingRate = new SqlParameter("@RMBPackingRate", "0");
SqlParameter RMBPackingPrice = new SqlParameter("@RMBPackingPrice", "0");
SqlParameter PKRPackingPrice = new SqlParameter("@PKRPackingPrice", "0");
SqlParameter SRNO = new SqlParameter("@SrNo", txtSrNo);
SqlParameter CreateByNew = new SqlParameter("@CreateBy", UserID);
SqlParameter BranchP = new SqlParameter("@BranchID", BranchID);
AACommon.Execute("SP_DETAIL_INSERT", Con, SPID_1, ITEMID, UnitID, QtyIn, UnitPrice, TotalPrice, RMBValue, RMBUnitPrice, RMBTotalPrice, Type, Carry, ExtraCharges, BasicUnitPricePKR, BasicUnitPriceRMB, RMBPackingRate, RMBPackingPrice, PKRPackingPrice, SRNO, CreateByNew, BranchP);
SqlDataAdapter daLast = new SqlDataAdapter("Select Top(1) ID from SP_Detail where SPID='" + txtVoucherNo + "' order by ID Desc", Con);
DataTable dtLast = new DataTable();
daLast.Fill(dtLast);
if (dtLast.Rows.Count > 0)
{
SqlCommand cmdUpdateQtyOut = new SqlCommand("update SP_Detail set QtyAvailed='" + Balance + "' where ID='" + dtLast.Rows[0][0].ToString() + "' and Type='P'", Con);
Con.Open();
cmdUpdateQtyOut.ExecuteNonQuery();
Con.Close();
SqlCommand cmdupdate = new SqlCommand("update SP_Detail set BatchID='" + dtLast.Rows[0][0].ToString() + "' where BatchID='" + BatchID + "' and Type='S'", Con);
Con.Open();
cmdupdate.ExecuteNonQuery();
Con.Close();
}
}
////////////////////SAVE TRANSACTION IN ACCOUNTS ////////////////////
double totafterdiscountPKR = Convert.ToDouble(txtSupplierPKR);
double totafterdiscountRMB = Convert.ToDouble(txtSupplierRMB);
string Narration = "Purchase By PO # " + rqID + "";
SqlCommand cmd = new SqlCommand("insert into tbl_transaction (Date,Narration,AmountPKR,AmountRMB,RMBValue,TaskID,CreateBy,BranchID) values ('" + txtVDate + "','" + Narration + "','" + totafterdiscountPKR + "','" + totafterdiscountRMB + "','" + RMBValueHDN + "','" + rqID + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmd.ExecuteNonQuery();
Con.Close();
string PurchaseAccount = "";
SqlDataAdapter daPurchase = new SqlDataAdapter("select AccountsID from Accounts where BranchID='" + BranchID + "' and AccountsTitle='Purchases'", Con);
DataTable dtPurchase = new DataTable();
daPurchase.Fill(dtPurchase);
if (dtPurchase.Rows.Count > 0)
{
PurchaseAccount = dtPurchase.Rows[0][0].ToString();
}
///PURCHASE ENTRY
SqlCommand cmdPurchase1 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + PurchaseAccount + "','PURCHASE','" + totafterdiscountPKR + "','" + totafterdiscountRMB + "','0','0','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase1.ExecuteNonQuery();
Con.Close();
SqlCommand cmdPurchase2 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + ddlSupplier + "','PURCHASE','0','0','" + txtSupplierPKR + "','" + txtSupplierRMB + "','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase2.ExecuteNonQuery();
Con.Close();
return(msg + rqID);
}
public static string UpdateRegion(string SupplierID, string SupplierTitle, string SupplierCode, string Phone, string Fax, string Email, string AddressLine1, string AddressLine2, string NTN, string GST, string SRB, string opBal, string Bank1Title, string Bank1AccountNo, string Bank1BankName, string Bank2Title, string Bank2AccountNo, string Bank2BankName, string Bank3Title, string Bank3AccountNo, string Bank3BankName)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter SupplierID_P = new SqlParameter("@SupplierID", SupplierID);
SqlParameter SupplierTitle_P = new SqlParameter("@SupplierTitle", SupplierTitle);
SqlParameter SupplierCode_P = new SqlParameter("@SupplierCode", SupplierCode);
SqlParameter Phone_P = new SqlParameter("@Phone", Phone);
SqlParameter Fax_P = new SqlParameter("@Fax", Fax);
SqlParameter Email_P = new SqlParameter("@Email", Email);
SqlParameter AddressLine1_P = new SqlParameter("@AddressLine1", AddressLine1);
SqlParameter AddressLine2_P = new SqlParameter("@AddressLine2", AddressLine2);
SqlParameter NTN_P = new SqlParameter("@NTN", NTN);
SqlParameter GST_P = new SqlParameter("@GST", GST);
SqlParameter SRB_P = new SqlParameter("@SRB", SRB);
SqlParameter OpBal = new SqlParameter("@OpBal", opBal);
SqlParameter Bank1Title_P = new SqlParameter("@Bank1Title", Bank1Title);
SqlParameter Bank1AccountNo_p = new SqlParameter("@Bank1AccountNo", Bank1Title);
SqlParameter Bank1BankName_P = new SqlParameter("@Bank1BankName", Bank1BankName);
SqlParameter Bank2Title_P = new SqlParameter("@Bank2Title", Bank2Title);
SqlParameter Bank2AccountNo_P = new SqlParameter("@Bank2AccountNo", Bank2AccountNo);
SqlParameter Bank2BankName_P = new SqlParameter("@Bank2BankName", Bank2BankName);
SqlParameter Bank3Title_P = new SqlParameter("@Bank3Title", Bank3Title);
SqlParameter Bank3AccountNo_P = new SqlParameter("@Bank3AccountNo", Bank3AccountNo);
SqlParameter Bank3BankName_P = new SqlParameter("@Bank3BankName", Bank3BankName);
msg = AACommon.Execute("Supplier_Update", Conn, SupplierID_P, SupplierTitle_P, SupplierCode_P, Phone_P, Fax_P, Email_P, AddressLine1_P, AddressLine2_P, NTN_P, GST_P, SRB_P, OpBal, Bank1Title_P, Bank1AccountNo_p, Bank1BankName_P, Bank2Title_P, Bank2AccountNo_P, Bank2BankName_P, Bank3Title_P, Bank3AccountNo_P, Bank3BankName_P);
//cHANGES BY SA/
//Update_Account_OpBal
SqlConnection ConACC = new SqlConnection(ConfigurationManager.ConnectionStrings["ConACC"].ConnectionString);
string lgrID = AACommon.GetData("select LedgerID from Supplier where SupplierID='" + SupplierID + "'", Conn, "LedgerID");
string opD = "0"; string opC = "0";
if (Convert.ToDecimal(opBal) > 0)
{
opD = opBal; opC = "0";
}
else if (Convert.ToDecimal(opBal) < 0)
{
opD = "0"; opC = opBal;
}
SqlParameter L4_ID = new SqlParameter("@L4_ID", lgrID);
SqlParameter Opcr = new SqlParameter("@Opcr", opC);
SqlParameter Opdr = new SqlParameter("@Opdr", opD);
AACommon.Execute("Update_Account_OpBal", ConACC, L4_ID, Opcr, Opdr);
//cHANGES BY SA/
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public static string SaveTransaction(string UserID, string str, string txtTotAmount, string txtDiscount, string txtTaxRate, string txtTotTax, string txtGrandTotal, string ddlSupplier, string txtDiscountPKR, string txtCusAmountPKR, string ddlShop, string txtCustomerName, string txtContactNo, string txtAddress, string txtBillNo, string BranchID)
{
string msg = "";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
string rqID = "";
string rqHID = "";
string rqDt = "";
string rqBy = UserID;
string rqAt = "";
string stsID = "";// 0:Pending, 1:Approved, 2:Rejected
///////////////////////// ID GNERATOR /////////////////////////////
string aa = LoadNUMBER("CS", "SP_MASTER", "SPID", Con, BranchID);
string[] idDT = aa.Split('`');
rqID = idDT[0].ToString();
rqDt = idDT[1].ToString();
// rqHID = LoadHistoryID(rqID);
string txtVDate = Convert.ToString(DateTime.Now.Date);
/////////////////////////// INSERT in SP MASTER //////////////////
SqlParameter SPID = new SqlParameter("@SPID", rqID);
SqlParameter SPDate = new SqlParameter("@SPDate", DateTime.Now.Date);
SqlParameter TotalAmount = new SqlParameter("@TotalAmount", txtTotAmount);
SqlParameter DiscountAmount = new SqlParameter("@DiscountAmount", txtDiscount);
SqlParameter TaxAmount = new SqlParameter("@TaxAmount", txtTotTax);
SqlParameter TaxRate = new SqlParameter("@TaxRate", txtTaxRate);
SqlParameter GrandTotal = new SqlParameter("@GrandTotal", txtGrandTotal);
SqlParameter RMBAmount = new SqlParameter("@RMBAmount", txtGrandTotal);
SqlParameter AccountID = new SqlParameter("@AccountID", ddlSupplier);
SqlParameter SP = new SqlParameter("@SP", "S");
SqlParameter CarryAmountPKR = new SqlParameter("@CarryAmountPKR", "0");
SqlParameter CarryAmountRMB = new SqlParameter("@CarryAmountRMB", "0");
SqlParameter PackingAmountPKR = new SqlParameter("@PackingAmountPKR", "0");
SqlParameter PackingAmountRMB = new SqlParameter("@PackingAmountRMB", "0");
SqlParameter ExChargeAmountPKR = new SqlParameter("@ExChargeAmountPKR", "0");
SqlParameter ExChatgeAmountRMB = new SqlParameter("@ExChatgeAmountRMB", "0");
SqlParameter SupplierAmountPKR = new SqlParameter("@SupplierAmountPKR", "0");
SqlParameter SupplierAmountRMB = new SqlParameter("@SupplierAmountRMB", "0");
SqlParameter SalesDiscountPKR = new SqlParameter("@SalesDiscountPKR", txtDiscountPKR);
SqlParameter SalesDiscountRMB = new SqlParameter("@SalesDiscountRMB", txtDiscountPKR);
SqlParameter CusAmountPKR = new SqlParameter("@CusAmountPKR", txtCusAmountPKR);
SqlParameter CusAmountRMB = new SqlParameter("@CusAmountRMB", txtCusAmountPKR);
SqlParameter CarryID = new SqlParameter("@CarryID", "0");
SqlParameter ExChargesID = new SqlParameter("@ExChargesID", "0");
SqlParameter PackingID = new SqlParameter("@PackingID", "0");
SqlParameter ShopName = new SqlParameter("@ShopName", ddlShop);
SqlParameter CustomerName = new SqlParameter("@CustomerName", txtCustomerName);
SqlParameter CreateBy = new SqlParameter("@CreateBy", UserID);
SqlParameter CustomerContactNo = new SqlParameter("@CustomerContactNo", txtContactNo);
SqlParameter CustomerAddress = new SqlParameter("@CustomerAddress", txtAddress);
SqlParameter LocalBillNo = new SqlParameter("@LocalBillNo", txtBillNo);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
SqlParameter CashRcvd = new SqlParameter("@CashRcvd", txtTotAmount);
SqlParameter CashBalance = new SqlParameter("@CashBalance", "0");
AACommon.Execute("SP_MASTER_INSERT", Con, SPID, SPDate, TotalAmount, DiscountAmount, TaxAmount, TaxRate, GrandTotal, RMBAmount, AccountID, SP, CarryAmountPKR, CarryAmountRMB, PackingAmountPKR, PackingAmountRMB, ExChargeAmountPKR, ExChatgeAmountRMB, SupplierAmountPKR, SupplierAmountRMB, SalesDiscountPKR, SalesDiscountRMB, CusAmountPKR, CusAmountRMB, CarryID, ExChargesID, PackingID, ShopName, CustomerName, CreateBy, CustomerContactNo, CustomerAddress, LocalBillNo, Branch, CashRcvd, CashBalance);
/////////////////////// INSERT in SP DETAIL
string[] itmLST = str.Split('`');
int b = 0;
for (int i = 0; i < itmLST.Length; i++)
{
b = b + 1;
string[] itmROW = itmLST[i].Split('^');
//txtAccID + "^" + txtAccTitle + "^" + ddlUnit + "^" + txtQty + "^" + txtPrice + "^" + txtTotalPrice
string itmID = itmROW[0].ToString();
string txtQty = itmROW[1].ToString();
string txtPrice = itmROW[2].ToString();
string txtTotalPrice = itmROW[3].ToString();
string txtSrNo = Convert.ToString(b);
SqlParameter SPID_1 = new SqlParameter("@SPID", rqID);
SqlParameter ITEMID = new SqlParameter("@ITEMID", itmID);
SqlParameter UnitID = new SqlParameter("@UnitID", "ITEM-000050");
SqlParameter QtyIn = new SqlParameter("@QtyIn", txtQty);
SqlParameter UnitPrice = new SqlParameter("@UnitPrice", txtPrice);
SqlParameter TotalPrice = new SqlParameter("@TotalPrice", txtTotalPrice);
SqlParameter RMBValue = new SqlParameter("@RMBValue", txtTotalPrice);
SqlParameter RMBUnitPrice = new SqlParameter("@RMBUnitPrice", txtPrice);
SqlParameter RMBTotalPrice = new SqlParameter("@RMBTotalPrice", txtTotalPrice);
SqlParameter Type = new SqlParameter("@Type", "S");
SqlParameter BasicUnitPricePKR = new SqlParameter("@BasicUnitPricePKR", txtPrice);
SqlParameter BasicUnitPriceRMB = new SqlParameter("@BasicUnitPriceRMB", txtPrice);
SqlParameter SRNO = new SqlParameter("@SrNo", txtSrNo);
SqlParameter CreateByNew = new SqlParameter("@CreateBy", UserID);
SqlParameter BranchP = new SqlParameter("@BranchID", BranchID);
SqlParameter DescriptionP = new SqlParameter("@Description", "SALE BY POS");
AACommon.Execute("SP_DETAIL_INSERT_2", Con, SPID_1, ITEMID, UnitID, QtyIn, UnitPrice, TotalPrice, RMBValue, RMBUnitPrice, RMBTotalPrice, Type,
BasicUnitPricePKR, BasicUnitPriceRMB, SRNO, CreateByNew, BranchP, DescriptionP);
}
string RMBValueHDN = "0";
////////////// PRID = PRID.Replace(" Purchase # : ", "");
////////////// PRDID = PRDID.Replace(" ID : ", "");
////////////// SqlDataAdapter da = new SqlDataAdapter("select * from SP_DETAIL where SPID='" + PRID + "' and ITEMID='" + itmID + "' and ID='" + PRDID + "'", Con);
////////////// DataTable dt = new DataTable();
////////////// da.Fill(dt);
////////////// if (dt.Rows.Count > 0)
////////////// {
////////////// double AvailedQty = Convert.ToDouble(dt.Rows[0]["QtyAvailed"].ToString());
////////////// double Qty = Convert.ToDouble(txtQty);
////////////// AvailedQty = AvailedQty + Qty;
////////////// SqlCommand cmd = new SqlCommand("update SP_DETAIL set QtyAvailed='" + AvailedQty + "' where SPID='" + PRID + "' and ITEMID='" + itmID + "' and ID='" + PRDID + "'", Con);
////////////// Con.Open();
////////////// cmd.ExecuteNonQuery();
////////////// Con.Close();
////////////// SqlDataAdapter da1 = new SqlDataAdapter("select MAX(ID) from SP_DETAIL where SPID='" + rqID + "' and ITEMID='" + itmID + "'", Con);
////////////// DataTable dt1 = new DataTable();
////////////// da1.Fill(dt1);
////////////// if (dt1.Rows.Count > 0)
////////////// {
////////////// SqlCommand cmd1 = new SqlCommand("update SP_DETAIL set BatchID='" + PRDID + "' where ID='" + dt1.Rows[0][0].ToString() + "'", Con);
////////////// Con.Open();
////////////// cmd1.ExecuteNonQuery();
////////////// Con.Close();
////////////// }
////////////// }
//////////////}
////////////////////SAVE TRANSACTION IN ACCOUNTS ////////////////////
string FinalAmountPKR = "";
string FinalAmountRMB = "";
string txtCusAmountRMB = "";
if (Convert.ToDouble(txtTotTax) > 0)
{
FinalAmountPKR = Convert.ToString(Convert.ToDouble(txtTotAmount) + Convert.ToDouble(txtTotTax));
FinalAmountRMB = Convert.ToString(Convert.ToDouble(txtTotAmount) + Convert.ToDouble(txtTotTax));
}
string Narration = "Invoice By SO # " + rqID + "";
SqlCommand cmd2 = new SqlCommand("insert into tbl_transaction (Date,Narration,AmountPKR,AmountRMB,RMBValue,TaskID,CreateBy,BranchID) values ('" + txtVDate + "','" + Narration + "','" + txtTotAmount + "','" + txtTotAmount + "','" + RMBValueHDN + "','" + rqID + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmd2.ExecuteNonQuery();
Con.Close();
string SaleRevenuAccount = "";
string SaleDiscountAccount = "";
string SaleTaxAccount = "";
SqlDataAdapter daPurchase = new SqlDataAdapter("select AccountsID from Accounts where BranchID='" + BranchID + "' and AccountsTitle='Sales Revenue'", Con);
DataTable dtPurchase = new DataTable();
daPurchase.Fill(dtPurchase);
if (dtPurchase.Rows.Count > 0)
{
SaleRevenuAccount = dtPurchase.Rows[0][0].ToString();
}
SqlDataAdapter daDiscount = new SqlDataAdapter("select AccountsID from Accounts where BranchID='" + BranchID + "' and AccountsTitle='Sales Discount'", Con);
DataTable dtDiscount = new DataTable();
daDiscount.Fill(dtDiscount);
if (dtDiscount.Rows.Count > 0)
{
SaleDiscountAccount = dtDiscount.Rows[0][0].ToString();
}
SqlDataAdapter daTax = new SqlDataAdapter("select AccountsID from Accounts where BranchID='" + BranchID + "' and AccountsTitle='TAX Liability'", Con);
DataTable dtTax = new DataTable();
daTax.Fill(dtTax);
if (dtTax.Rows.Count > 0)
{
SaleTaxAccount = dtTax.Rows[0][0].ToString();
}
if (Convert.ToDouble(txtTotTax) > 0)
{
txtCusAmountPKR = Convert.ToString(Convert.ToDouble(txtCusAmountPKR) + Convert.ToDouble(txtTotTax));
txtCusAmountRMB = Convert.ToString(Convert.ToDouble(txtCusAmountRMB) + Convert.ToDouble(txtTotTax));
}
///PURCHASE ENTRY
SqlCommand cmdPurchase1 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + ddlSupplier + "','SALE','" + txtCusAmountPKR + "','" + txtCusAmountRMB + "','0','0','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase1.ExecuteNonQuery();
Con.Close();
if (Convert.ToDouble(txtDiscountPKR) > 0)
{
Narration = "Sales Discount By SO # " + rqID + "";
SqlCommand cmdPurchase3 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + SaleDiscountAccount + "','SALE','" + txtDiscountPKR + "','" + txtDiscountPKR + "','0','0','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase3.ExecuteNonQuery();
Con.Close();
}
if (Convert.ToDouble(txtTotTax) > 0)
{
Narration = "Sales Tax By SO # " + rqID + "";
SqlCommand cmdPurchase3 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + SaleTaxAccount + "','SALE','0','0','" + txtTotTax + "','" + txtTotTax + "','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase3.ExecuteNonQuery();
Con.Close();
}
Narration = "Invoice By SO # " + rqID + "";
SqlCommand cmdPurchase2 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy,BranchID) values ('" + txtVDate + "','" + SaleRevenuAccount + "','SALE','0','0','" + txtTotAmount + "','" + txtDiscountPKR + "','" + RMBValueHDN + "','" + rqID + "','" + Narration + "','" + UserID + "','" + BranchID + "')", Con);
Con.Open();
cmdPurchase2.ExecuteNonQuery();
Con.Close();
///PURCHASE ENTRY
return(msg);
}
public static string InsertRegion(string SupplierTitle, string SupplierCode, string Phone, string Fax, string Email, string AddressLine1, string AddressLine2, string NTN, string GST, string SRB, string opBal, string UserID)
{
string retMessage = string.Empty;
string msg = "";
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlConnection ConACC = new SqlConnection(ConfigurationManager.ConnectionStrings["ConACC"].ConnectionString);
string ID = AACommon.GetAlphaNumericIDSIX("Supplier", "SIP-", "SupplierID", Conn);
SqlParameter SupplierID_P = new SqlParameter("@SupplierID", ID);
SqlParameter SupplierTitle_P = new SqlParameter("@SupplierTitle", SupplierTitle);
SqlParameter SupplierCode_P = new SqlParameter("@SupplierCode", SupplierCode);
SqlParameter Phone_P = new SqlParameter("@Phone", Phone);
SqlParameter Fax_P = new SqlParameter("@Fax", Fax);
SqlParameter Email_P = new SqlParameter("@Email", Email);
SqlParameter AddressLine1_P = new SqlParameter("@AddressLine1", AddressLine1);
SqlParameter AddressLine2_P = new SqlParameter("@AddressLine2", AddressLine2);
SqlParameter NTN_P = new SqlParameter("@NTN", NTN);
SqlParameter GST_P = new SqlParameter("@GST", GST);
SqlParameter SRB_P = new SqlParameter("@SRB", SRB);
SqlParameter OpBal = new SqlParameter("@OpBal", opBal);
SqlParameter CREATEBY = new SqlParameter("@CreateBy", UserID);
msg = AACommon.Execute("Supplier_Insert", Conn, SupplierID_P, SupplierTitle_P, SupplierCode_P, Phone_P, Fax_P, Email_P, AddressLine1_P, AddressLine2_P, NTN_P, GST_P, SRB_P, OpBal, CREATEBY);
/////////////////////ACCOUNTS /////////////////////////
string opD = "0"; string opC = "0";
if (Convert.ToDecimal(opBal) > 0)
{
opD = opBal; opC = "0";
}
else if (Convert.ToDecimal(opBal) < 0)
{
opD = "0"; opC = opBal;
}
string L4ID = AACommon.GetData("SELECT AccountID FROM AACCOUNTS_Integration WHERE (Description = 'Vendors')", ConACC, "AccountID");
string ledgerID = AACommon.GetAlphaNumericIDTHREE("Accounts", L4ID, "L4_ID", ConACC);
SqlParameter L4_ID = new SqlParameter("@L4_ID", ledgerID);
SqlParameter Desc_Level4 = new SqlParameter("@Desc_Level4", SupplierTitle);
SqlParameter L4_IDNew = new SqlParameter("@L4_IDNew", L4ID);
SqlParameter Opdr = new SqlParameter("@Opdr", opD);
SqlParameter Opcr = new SqlParameter("@Opcr", opC);
SqlParameter CompanyID = new SqlParameter("@CompanyID", "12");
SqlParameter FiscalID = new SqlParameter("@FiscalID", "22");
SqlParameter BalanceValidation = new SqlParameter("@BalanceValidation", "0");
AACommon.Execute("Insert_Accounts", ConACC, L4_ID, Desc_Level4, L4_IDNew, Opdr, Opcr, CompanyID, FiscalID, BalanceValidation);
/////////////////////////////////////
string str = "update Supplier set LedgerID='" + ledgerID + "' where SupplierID='" + ID + "'";
SqlCommand cmd = new SqlCommand(str, Conn);
if (Conn.State == ConnectionState.Closed)
{
Conn.Open();
}
cmd.ExecuteNonQuery();
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
if (msg == "Record Saved Successfully")
{
retMessage = "true";
}
else
{
retMessage = "false";
}
return(retMessage);
}
public void GetStock()
{
SqlCommand cmdDelete = new SqlCommand("delete from AA_STOCK_OPENING_TEMP", Conn);
Conn.Open();
cmdDelete.ExecuteNonQuery();
Conn.Close();
SqlDataAdapter da = new SqlDataAdapter("select * from VW_TEMP_AVAILABLE_STOCK_FOR_OPENING", Conn);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
SqlCommand cmd = new SqlCommand("insert into AA_STOCK_OPENING_TEMP (ITEMID,UnitID,Qty,UnitPrice,RMBValue,RMBUnitPrice) values ('" + dt.Rows[i]["ITEMID"].ToString() + "','UN-000050','" + dt.Rows[i]["Qty"].ToString() + "','" + dt.Rows[i]["UnitPrice"].ToString() + "','17','" + Convert.ToDouble(dt.Rows[i]["UnitPrice"].ToString()) / 17 + "')", Conn);
Conn.Open();
cmd.ExecuteNonQuery();
Conn.Close();
}
SqlCommand cmdupdate = new SqlCommand("update AA_STOCK_OPENING_TEMP set RMBTotalPrice=Qty*RMBUnitPrice,TotalPrice=Qty*UnitPrice", Conn);
Conn.Open();
cmdupdate.ExecuteNonQuery();
Conn.Close();
SqlCommand cmdupdateDecimal = new SqlCommand("update AA_STOCK_OPENING_TEMP set TotalPrice=cast(TotalPrice as decimal(10,2)), RMBUnitPrice=cast(RMBUnitPrice as decimal(10,2)),RMBTotalPrice=cast(RMBTotalPrice as decimal(10,2))", Conn);
Conn.Open();
cmdupdateDecimal.ExecuteNonQuery();
Conn.Close();
//
string rqID = "";
string rqDt = "";
///////////////////////// ID GNERATOR /////////////////////////////
string aa = LoadNUMBER("PR", "SP_MASTER", "SPID", Con);
string[] idDT = aa.Split('`');
rqID = idDT[0].ToString();
rqDt = idDT[1].ToString();
// rqHID = LoadHistoryID(rqID);
SqlDataAdapter da2 = new SqlDataAdapter("select sum(RMBTotalPrice) AS RMBTotalPrice,sum(TotalPrice) AS TotalPrice from AA_STOCK_OPENING_TEMP", Conn);
DataTable dt2 = new DataTable();
da2.Fill(dt2);
if (dt2.Rows.Count > 0)
{
/////////////////////////// INSERT in SP MASTER //////////////////
SqlParameter SPID = new SqlParameter("@SPID", rqID);
SqlParameter SPDate = new SqlParameter("@SPDate", DateTime.Now);
SqlParameter TotalAmount = new SqlParameter("@TotalAmount", dt2.Rows[0]["TotalPrice"].ToString());
SqlParameter DiscountAmount = new SqlParameter("@DiscountAmount", '0');
SqlParameter TaxAmount = new SqlParameter("@TaxAmount", '0');
SqlParameter TaxRate = new SqlParameter("@TaxRate", '0');
SqlParameter GrandTotal = new SqlParameter("@GrandTotal", dt2.Rows[0]["TotalPrice"].ToString());
SqlParameter RMBAmount = new SqlParameter("@RMBAmount", dt2.Rows[0]["RMBTotalPrice"].ToString());
SqlParameter AccountID = new SqlParameter("@AccountID", "89");
SqlParameter SP = new SqlParameter("@SP", "P");
SqlParameter CarryAmountPKR = new SqlParameter("@CarryAmountPKR", "0");
SqlParameter CarryAmountRMB = new SqlParameter("@CarryAmountRMB", "0");
SqlParameter PackingAmountPKR = new SqlParameter("@PackingAmountPKR", "0");
SqlParameter PackingAmountRMB = new SqlParameter("@PackingAmountRMB", "0");
SqlParameter ExChargeAmountPKR = new SqlParameter("@ExChargeAmountPKR", "0");
SqlParameter ExChatgeAmountRMB = new SqlParameter("@ExChatgeAmountRMB", "0");
SqlParameter SupplierAmountPKR = new SqlParameter("@SupplierAmountPKR", dt2.Rows[0]["TotalPrice"].ToString());
SqlParameter SupplierAmountRMB = new SqlParameter("@SupplierAmountRMB", dt2.Rows[0]["RMBTotalPrice"].ToString());
SqlParameter SalesDiscountPKR = new SqlParameter("@SalesDiscountPKR", '0');
SqlParameter SalesDiscountRMB = new SqlParameter("@SalesDiscountRMB", '0');
SqlParameter CusAmountPKR = new SqlParameter("@CusAmountPKR", "0");
SqlParameter CusAmountRMB = new SqlParameter("@CusAmountRMB", "0");
SqlParameter CarryID = new SqlParameter("@CarryID", "0");
SqlParameter ExChargesID = new SqlParameter("@ExChargesID", "0");
SqlParameter PackingID = new SqlParameter("@PackingID", "0");
SqlParameter ShopName = new SqlParameter("@ShopName", "");
SqlParameter CustomerName = new SqlParameter("@CustomerName", "");
SqlParameter CreateBy = new SqlParameter("@CreateBy", "USR-000001");
SqlParameter CustomerContactNo = new SqlParameter("@CustomerContactNo", "");
SqlParameter CustomerAddress = new SqlParameter("@CustomerAddress", "");
SqlParameter LocalBillNo = new SqlParameter("@LocalBillNo", "");
AACommon.Execute("SP_MASTER_INSERT", Con, SPID, SPDate, TotalAmount, DiscountAmount, TaxAmount, TaxRate, GrandTotal, RMBAmount, AccountID, SP, CarryAmountPKR, CarryAmountRMB, PackingAmountPKR, PackingAmountRMB, ExChargeAmountPKR, ExChatgeAmountRMB, SupplierAmountPKR, SupplierAmountRMB, SalesDiscountPKR, SalesDiscountRMB, CusAmountPKR, CusAmountRMB, CarryID, ExChargesID, PackingID, ShopName, CustomerName, CreateBy, CustomerContactNo, CustomerAddress, LocalBillNo);
/////////////////////// INSERT in SP DETAIL
SqlDataAdapter da3 = new SqlDataAdapter("select * from AA_STOCK_OPENING_TEMP", Conn);
DataTable dt3 = new DataTable();
da3.Fill(dt3);
if (dt3.Rows.Count > 0)
{
for (int j = 0; j < dt3.Rows.Count; j++)
{
SqlParameter SPID_1 = new SqlParameter("@SPID", rqID);
SqlParameter ITEMID = new SqlParameter("@ITEMID", dt3.Rows[j]["ITEMID"].ToString());
SqlParameter UnitID = new SqlParameter("@UnitID", "UN-000050");
SqlParameter QtyIn = new SqlParameter("@QtyIn", dt3.Rows[j]["Qty"].ToString());
SqlParameter UnitPrice = new SqlParameter("@UnitPrice", dt3.Rows[j]["UnitPrice"].ToString());
SqlParameter TotalPrice = new SqlParameter("@TotalPrice", dt3.Rows[j]["TotalPrice"].ToString());
SqlParameter RMBValue = new SqlParameter("@RMBValue", dt3.Rows[j]["RMBValue"].ToString());
SqlParameter RMBUnitPrice = new SqlParameter("@RMBUnitPrice", dt3.Rows[j]["RMBUnitPrice"].ToString());
SqlParameter RMBTotalPrice = new SqlParameter("@RMBTotalPrice", dt3.Rows[j]["RMBTotalPrice"].ToString());
SqlParameter Type = new SqlParameter("@Type", "P");
SqlParameter Carry = new SqlParameter("@Carry", "0");
SqlParameter ExtraCharges = new SqlParameter("@ExtraCharges", "0");
SqlParameter BasicUnitPricePKR = new SqlParameter("@BasicUnitPricePKR", dt3.Rows[j]["UnitPrice"].ToString());
SqlParameter BasicUnitPriceRMB = new SqlParameter("@BasicUnitPriceRMB", dt3.Rows[j]["RMBUnitPrice"].ToString());
SqlParameter RMBPackingRate = new SqlParameter("@RMBPackingRate", "0");
SqlParameter RMBPackingPrice = new SqlParameter("@RMBPackingPrice", "0");
SqlParameter PKRPackingPrice = new SqlParameter("@PKRPackingPrice", "0");
SqlParameter SRNO = new SqlParameter("@SrNo", j);
SqlParameter CreateByNew = new SqlParameter("@CreateBy", "USR-000001");
AACommon.Execute("SP_DETAIL_INSERT", Con, SPID_1, ITEMID, UnitID, QtyIn, UnitPrice, TotalPrice, RMBValue, RMBUnitPrice, RMBTotalPrice, Type, Carry, ExtraCharges, BasicUnitPricePKR, BasicUnitPriceRMB, RMBPackingRate, RMBPackingPrice, PKRPackingPrice, SRNO, CreateByNew);
}
}
////////////////////SAVE TRANSACTION IN ACCOUNTS ////////////////////
double totafterdiscountPKR = Convert.ToDouble(dt2.Rows[0]["TotalPrice"].ToString());
double totafterdiscountRMB = Convert.ToDouble(dt2.Rows[0]["RMBTotalPrice"].ToString());
string Narration = "Opening Purchase against PO Number " + rqID + "";
SqlCommand cmd = new SqlCommand("insert into tbl_transaction (Date,Narration,AmountPKR,AmountRMB,RMBValue,TaskID,CreateBy) values ('" + DateTime.Now + "','" + Narration + "','" + totafterdiscountPKR + "','" + totafterdiscountRMB + "','17','" + rqID + "','USR-000001')", Con);
Con.Open();
cmd.ExecuteNonQuery();
Con.Close();
///PURCHASE ENTRY
SqlCommand cmdPurchase1 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy) values ('" + DateTime.Now + "','49','PURCHASE','" + totafterdiscountPKR + "','" + totafterdiscountRMB + "','0','0','17','" + rqID + "','" + Narration + "','USR-000001')", Con);
Con.Open();
cmdPurchase1.ExecuteNonQuery();
Con.Close();
SqlCommand cmdPurchase2 = new SqlCommand("insert into Transaction_Detail (Date,AccountID,TransactionType,DebitPKR,DebitRMB,CreditPKR,CreditRMB,RMBValue,TaskID,Narration,CreateBy) values ('" + DateTime.Now + "','89','PURCHASE','0','0','" + totafterdiscountPKR + "','" + totafterdiscountRMB + "','17','" + rqID + "','" + Narration + "','USR-000001')", Con);
Con.Open();
cmdPurchase2.ExecuteNonQuery();
Con.Close();
}
}
}
