private void btnOk_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (dtExcelData == null)
{
return;
}
if (CheckColumns() == false)
{
return;
}
string sVendorName = "";
string sVAddress = "";
string sContactNo = "";
string sEmail = "";
string sCSTNo = "";
string sTNGSTNo = "";
string sTIN = "";
string sPAN = "";
int iSupply = 0;
int iContract = 0;
int iService = 0;
for (int i = 0; i < dtExcelData.Rows.Count; i++)
{
sVendorName = dtExcelData.Rows[i]["VendorName"].ToString();
if (VendorBL.IsValidName(sVendorName) == true && sVendorName != "")
{
sVAddress = dtExcelData.Rows[i]["Address"].ToString();
sContactNo = dtExcelData.Rows[i]["ContactNo"].ToString();
sEmail = dtExcelData.Rows[i]["EmailId"].ToString();
sCSTNo = dtExcelData.Rows[i]["CSTNo"].ToString();
sTNGSTNo = dtExcelData.Rows[i]["TNGST"].ToString();
sTIN = dtExcelData.Rows[i]["TIN"].ToString();
sPAN = dtExcelData.Rows[i]["PAN"].ToString();
iSupply = Convert.ToInt32(clsStatic.IsNullCheck(dtExcelData.Rows[i]["Supply"].ToString(), clsStatic.datatypes.vartypenumeric));
iContract = Convert.ToInt32(clsStatic.IsNullCheck(dtExcelData.Rows[i]["Contract"].ToString(), clsStatic.datatypes.vartypenumeric));
iService = Convert.ToInt32(clsStatic.IsNullCheck(dtExcelData.Rows[i]["Service"].ToString(), clsStatic.datatypes.vartypenumeric));
VendorBL.ImportTransaction(sVendorName, sVAddress, sContactNo, sEmail, sCSTNo, sTNGSTNo, sTIN, sPAN, iSupply, iContract, iService);
}
}
if (BsfGlobal.g_bFADB == true)
{
BsfGlobal.RefreshSubLedger(1);
}
MessageBox.Show("Imported Successfully!", "Vendor", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
}
public int InsertVendorMaster(Vendor.BusinessLayer.VendorBL argVendor)
{
SqlConnection conn;
conn = new SqlConnection();
conn = BsfGlobal.OpenVendorAnalDB();
SqlTransaction tran = conn.BeginTransaction();
int iCId = 0;
try
{
SqlCommand Command = new SqlCommand("Insert_VendorMaster", conn, tran);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@VendorId", argVendor.VendorId);
Command.Parameters["@VendorId"].Direction = ParameterDirection.Output;
Command.Parameters.AddWithValue("@VendorName", argVendor.VendorName);
Command.Parameters.AddWithValue("@Supply", argVendor.Supply);
Command.Parameters.AddWithValue("@Contract", argVendor.Contract);
Command.Parameters.AddWithValue("@Service", argVendor.Service);
Command.Parameters.AddWithValue("@Address", argVendor.RegAddress);
Command.Parameters.AddWithValue("@CityId", argVendor.CityId);
Command.Parameters.AddWithValue("@Pin", argVendor.PinNo);
Command.Parameters.AddWithValue("@STypeId", argVendor.STypeId);
Command.Parameters.AddWithValue("@Company", argVendor.iCompany);
Command.Parameters.AddWithValue("@SuppTypeId", argVendor.SuppTypeId);
Command.Parameters.AddWithValue("@ChequeNo", argVendor.ChequeNo);
Command.Parameters.AddWithValue("@Code", argVendor.Code);
Command.ExecuteNonQuery();
iCId = (int)Command.Parameters["@VendorId"].Value;
tran.Commit();
if (BsfGlobal.g_bVendorDB == true)
{
BsfGlobal.RefreshSubLedger(1);
}
}
catch
{
tran.Rollback();
}
finally
{
conn.Close();
}
return(iCId);
}