public IList <POS.BO.Brand> GetBrandList(int?SBID, int?SBGID, int?BrandID)
{
try
{
//string SBG = "";
//if (SBGID == 3)
//{
// SBG = "1,2";
//}
//else
//{
// SBG = SBGID.ToString();
//}
SqlConnection con = CreateCon();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.CommandText = "DCR_SP_GET_BrandByParameter";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = con;
da.SelectCommand.Parameters.Add("@BrandID", System.Data.SqlDbType.Int).Value = BrandID;
da.SelectCommand.Parameters.Add("@SBGID", System.Data.SqlDbType.VarChar, 10).Value = SBGID;
da.SelectCommand.Parameters.Add("@SBID", System.Data.SqlDbType.Int).Value = SBID;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DataSet ds = new DataSet();
da.Fill(ds);
if (con.State == ConnectionState.Open)
{
con.Close();
}
DataTable dt = ds.Tables[0];
List <POS.BO.Brand> objDoctorList = new List <POS.BO.Brand>();
POS.BO.Brand obj = null;
int index = 1;
foreach (DataRow row in dt.Rows)
{
obj = new BO.Brand();
obj.Sln = index++;
obj.BrandID = Convert.ToInt32(row["BrandID"]);
obj.BrandName = row["BrandName"].ToString();
obj.BrandDescription = row["BrandDescription"].ToString();
//obj.SBGID = Convert.ToInt32(row["SBG"].ToString());
//obj.SBGName = Convert.ToString(row["SBGName"].ToString());
objDoctorList.Add(obj);
}
return(objDoctorList);
}
catch (Exception ex)
{
throw ex;
}
}
public IList <POS.BO.Brand> GetTerritoryWiseSBGAndBrand(long EmployeeID)
{
try
{
SqlConnection con = CreateCon();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.CommandText = "DCR_SP_GET_TerritoryWiseSBGAndBrand";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = con;
da.SelectCommand.Parameters.Add("@EmployeeID", System.Data.SqlDbType.BigInt).Value = EmployeeID;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DataSet ds = new DataSet();
da.Fill(ds);
if (con.State == ConnectionState.Open)
{
con.Close();
}
DataTable dt = ds.Tables[0];
List <POS.BO.Brand> objBrandList = new List <POS.BO.Brand>();
POS.BO.Brand obj = null;
int index = 1;
foreach (DataRow row in dt.Rows)
{
obj = new BO.Brand();
obj.Sln = index++;
obj.BrandID = Convert.ToInt32(row["BrandID"]);
//obj.SBGID = Convert.ToInt32(row["SBGID"]);
obj.BrandName = row["BrandName"].ToString();
obj.BrandDescription = row["BrandDescription"].ToString();
//obj.SBGName = row["SBGName"].ToString();
objBrandList.Add(obj);
}
return(objBrandList);
}
catch (Exception ex)
{
throw ex;
}
}
public IList <BO.Brand> GetBrandList()
{
try
{
SqlConnection con = CreateCon();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.CommandText = "[POS_SP_GET_GETBrand]";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = con;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DataSet ds = new DataSet();
da.Fill(ds);
if (con.State == ConnectionState.Open)
{
con.Close();
}
DataTable dt = ds.Tables[0];
List <POS.BO.Brand> objBrandList = new List <POS.BO.Brand>();
POS.BO.Brand obj = null;
int index = 1;
foreach (DataRow row in dt.Rows)
{
obj = new BO.Brand();
obj.Sln = index++;
obj.BrandID = Convert.ToInt32(row["BrandID"]);
obj.BrandName = row["BrandName"].ToString();
obj.BrandDescription = row["BrandDescription"].ToString();
objBrandList.Add(obj);
}
return(objBrandList);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(BO.Brand objBrand)
{
try
{
int returnStatus = 0;
SqlConnection con = CreateCon();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.CommandText = "[POS_SP_Update_SET_Brand]";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = con;
da.SelectCommand.Parameters.Add("@BrandID", System.Data.SqlDbType.Int).Value = objBrand.BrandID;
da.SelectCommand.Parameters.Add("@BrandName", System.Data.SqlDbType.VarChar, 100).Value = objBrand.BrandName;
da.SelectCommand.Parameters.Add("@BrandDescription", System.Data.SqlDbType.VarChar, 100).Value = objBrand.BrandDescription;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
if (da.SelectCommand.ExecuteNonQuery() == 1)
{
returnStatus = 1;
}
else
{
returnStatus = 0;
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
return(returnStatus);
}
catch (Exception ex)
{
throw ex;
}
}
public int UpdateSBGWiseBrand(BO.Brand objBrand)
{
try
{
int retunstatus = 0;
int transationStatus = 0;
using (var connection = new DCommon().CreateCon())
{
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = connection.CreateCommand();
SqlTransaction transaction = null;
try
{
// BeginTransaction() Requires Open Connection
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
transaction = connection.BeginTransaction();
// Assign Transaction to Command
da.SelectCommand.Connection = connection;
da.SelectCommand.Transaction = transaction;
da.SelectCommand.CommandText = "DCR_SP_Update_Brand";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@BrandID", System.Data.SqlDbType.BigInt).Value = objBrand.BrandID;
da.SelectCommand.Parameters.Add("@BrandName", System.Data.SqlDbType.VarChar, 100).Value = objBrand.BrandName;
da.SelectCommand.Parameters.Add("@BrandDescription", System.Data.SqlDbType.VarChar, 500).Value = objBrand.BrandDescription;
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = connection;
transationStatus = da.SelectCommand.ExecuteNonQuery();
da.SelectCommand.Parameters.Clear();
if (transationStatus <= 0)
{
transaction.Rollback();
//break;
}
else
{
//foreach (var objSBG in objBrand.SBGBrnadList)
//{
// if (objSBG.IsNewData == true)
// {
// #region InsertBrandWiseSBG
// da.SelectCommand.CommandText = "DCR_SP_INSERT_BrandWiseSBG";
// da.SelectCommand.Parameters.Add("@BrandID", System.Data.SqlDbType.Int).Value = objBrand.BrandID;
// da.SelectCommand.Parameters.Add("@SBGID", System.Data.SqlDbType.Int).Value = objSBG.SBGID;
// da.SelectCommand.CommandType = CommandType.StoredProcedure;
// transationStatus = da.SelectCommand.ExecuteNonQuery();
// da.SelectCommand.Parameters.Clear();
// #endregion
// }
// if (objSBG.IsDelete == true)
// {
// #region DeleteBrandWiseSBG
// da.SelectCommand.CommandText = "DCR_SP_DELETE_SBGWiseBrand";
// da.SelectCommand.Parameters.Add("@BrandID", System.Data.SqlDbType.BigInt).Value = objBrand.BrandID;
// da.SelectCommand.Parameters.Add("@SBGID", System.Data.SqlDbType.Int).Value = objSBG.SBGID;
// da.SelectCommand.CommandType = CommandType.StoredProcedure;
// transationStatus = da.SelectCommand.ExecuteNonQuery();
// da.SelectCommand.Parameters.Clear();
// #endregion
// }
//}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
if (transationStatus == 1)
{
retunstatus = 1;
}
}
}
return(retunstatus);
}
catch (Exception ex)
{
throw ex;
}
}
public IList <BO.Brand> GetBrandByObject(BO.Brand objBrand, int pageIndex, int pageSize, string orderBy, string sortindex)
{
return(new List <POS.BO.Brand>());
}
public int UpdateSBGWiseBrand(BO.Brand objBrand)
{
return(_iBrand.UpdateSBGWiseBrand(objBrand));
}
public int InsertSBGWiseBrand(BO.Brand objBrand)
{
return(_iBrand.InsertSBGWiseBrand(objBrand));
}
public IList <BO.Brand> GetBrandByObject(BO.Brand objBrand, int pageIndex, int pageSize, string orderBy, string sortindex)
{
return(_iBrand.GetBrandByObject(objBrand, pageIndex, pageSize, orderBy, sortindex));
}
public int Update(BO.Brand objBrand)
{
return(_iBrand.Update(objBrand));
}
public int Insert(BO.Brand objBrand)
{
return(_iBrand.Insert(objBrand));
}
