public bool InsertNewItem(U_ADM_ITEM_MASTER item)
{
A_ADM_ITEM_MASTERDAL obj = new A_ADM_ITEM_MASTERDAL();
U_ADM_MEDIA_MASTERDAL objImg = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = item.Media_Id_Img;
imgData.Media_Source = "";
imgData.Media_Oth_Dtl = "";
imgData.Created_by = item.Created_by;
imgData.Updated_by = item.Updated_by;
imgData.Created_Date = DateTime.Now;
imgData.Updated_Date = DateTime.Now;
item.Item_Id = imgData.Media_Id;
item.Item_Status = "1";
item.Item_Source = "No Source";
item.Media_Id_Video = " ";
item.Created_Date = DateTime.Now;
item.Updated_Date = DateTime.Now;
if (objImg.InsertU_ADM_MEDIA_MASTER(imgData))
{
item.Media_Id_Img = imgData.Media_Id;
if (obj.InsertU_ADM_ITEM_MASTER(item))
{
return(true);
}
}
return(false);
}
public bool UpdateItemMaster(U_ADM_ITEM_MASTER item)
{
SqlParameter[] aParms = GetParameters(item);
SetParameters(aParms, item);
using (SqlConnection conn = General.GetConnection())
{
bool status = false;
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SQL_UPDATE_U_ADM_ITEM_MASTER, aParms);
trans.Commit();
status = true;
}
catch (System.Exception e)
{
Console.Write(e);
trans.Rollback();
//log.Error(lobjError, e);
throw;
}
}
return(status);
}
}
public U_ADM_ITEM_MASTER SelectItemDetailsDb(string id)
{
SqlConnection con = null;
SqlParameter[] aParms = new SqlParameter[] { new SqlParameter(PARAM_Item_Id, id) };
U_ADM_ITEM_MASTER item = new U_ADM_ITEM_MASTER();
try
{
con = General.GetConnection();
SqlDataReader reader = SqlHelper.ExecuteReader(con, CommandType.Text, SQL_SELECT_ALL, aParms);
while (reader.Read())
{
item.Item_Id = reader.GetString(0);
item.Item_Name = reader.GetString(1);
item.Item_Desc = reader.GetString(2);
item.Item_Status = reader.GetString(3);
item.Item_Tentative_Cost = reader.GetDecimal(4);
item.Item_Source = reader.GetString(5);
item.Media_Id_Img = reader.GetString(6);
item.Media_Id_Video = reader.GetString(7);
item.Created_Date = reader.GetDateTime(8);
item.Updated_Date = reader.GetDateTime(9);
item.Created_by = reader.GetString(10);
item.Updated_by = reader.GetString(11);
}
reader.Close();
return(item);
}
catch (Exception e)
{
Console.Write(e);
return(null);
}
}
private void SetParameters(SqlParameter[] U_ADM_MEDIA_MASTERParms, U_ADM_ITEM_MASTER toObjU_ADM_ITEM_MASTER)
{
U_ADM_MEDIA_MASTERParms[0].Value = toObjU_ADM_ITEM_MASTER.Item_Id;
U_ADM_MEDIA_MASTERParms[1].Value = toObjU_ADM_ITEM_MASTER.Item_Name;
U_ADM_MEDIA_MASTERParms[2].Value = toObjU_ADM_ITEM_MASTER.Item_Desc;
U_ADM_MEDIA_MASTERParms[3].Value = toObjU_ADM_ITEM_MASTER.Item_Status;
U_ADM_MEDIA_MASTERParms[4].Value = toObjU_ADM_ITEM_MASTER.Item_Tentative_Cost;
U_ADM_MEDIA_MASTERParms[5].Value = toObjU_ADM_ITEM_MASTER.Item_Source;
U_ADM_MEDIA_MASTERParms[6].Value = toObjU_ADM_ITEM_MASTER.Media_Id_Img;
U_ADM_MEDIA_MASTERParms[7].Value = toObjU_ADM_ITEM_MASTER.Media_Id_Video;
U_ADM_MEDIA_MASTERParms[8].Value = toObjU_ADM_ITEM_MASTER.Created_Date;
U_ADM_MEDIA_MASTERParms[9].Value = toObjU_ADM_ITEM_MASTER.Updated_Date;
U_ADM_MEDIA_MASTERParms[10].Value = toObjU_ADM_ITEM_MASTER.Created_by;
U_ADM_MEDIA_MASTERParms[11].Value = toObjU_ADM_ITEM_MASTER.Updated_by;
}
public bool UpdateItem(A_ADM_ITEM_MASTER item)
{
A_ADM_ITEM_MASTERDAL ItemDAL = new A_ADM_ITEM_MASTERDAL();
U_ADM_ITEM_MASTER OldData = new U_ADM_ITEM_MASTER();
U_ADM_ITEM_MASTER NewData = new U_ADM_ITEM_MASTER();
U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
OldData = ItemDAL.SelectItemDetailsDb(item.Item_ID);
if (!(item.Item_PicUrl == "/img/default_product.png") && !(string.IsNullOrEmpty(item.Item_PicUrl)))
{
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = item.Item_PicUrl;
imgData.Media_Source = "";
imgData.Media_Oth_Dtl = "";
imgData.Created_by = item.Update_By;
imgData.Updated_by = item.Update_By;
imgData.Created_Date = DateTime.Now;
imgData.Updated_Date = DateTime.Now;
ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData);
NewData.Media_Id_Img = imgData.Media_Id;
}
else
{
NewData.Media_Id_Img = OldData.Media_Id_Img;
}
NewData.Item_Id = item.Item_ID;
NewData.Item_Name = string.IsNullOrEmpty(item.Item_Name) ? OldData.Item_Name : item.Item_Name;
NewData.Item_Desc = string.IsNullOrEmpty(item.Item_Desc) ? OldData.Item_Desc : item.Item_Desc;
NewData.Item_Status = string.IsNullOrEmpty(item.Item_Status) ? OldData.Item_Status : item.Item_Status;
NewData.Item_Tentative_Cost = string.IsNullOrEmpty(Convert.ToString(item.Item_Price)) ? OldData.Item_Tentative_Cost : item.Item_Price;
NewData.Item_Source = string.IsNullOrEmpty(item.Item_Source) ? OldData.Item_Source : item.Item_Source;
NewData.Media_Id_Video = OldData.Media_Id_Video;
NewData.Created_by = OldData.Created_by;
NewData.Created_Date = OldData.Created_Date;
NewData.Updated_by = string.IsNullOrEmpty(item.Update_By) ? OldData.Updated_by : item.Update_By;
NewData.Updated_Date = DateTime.Now;
if (ItemDAL.UpdateItemMaster(NewData))
{
return(true);
}
return(false);
}
public bool InsertU_ADM_ITEM_MASTER(U_ADM_ITEM_MASTER obj)
{
if (obj != null)
{
SqlParameter[] lParamArray = GetParameters(obj);
SetParameters(lParamArray, obj);
SqlConnection con = General.GetConnection();
if (con == null)
{
//Connection is not created
return(false);
}
//Execute the insertion
int i = SqlHelper.ExecuteNonQuery(
con,
CommandType.Text,
SQL_INSERT_U_ADM_ITEM_MASTER,
lParamArray);
//Dispose the Sql connection
con.Dispose();
if (i == 1)
{
//Done and insert the object to the table
return(true);
}
else
{
//Fail to execute the insertion
return(false);
}
}
else
{
//No object found to insert
return(false);
}
}
private SqlParameter[] GetParameters(U_ADM_ITEM_MASTER toObjU_ADM_ITEM_MASTER)
{
SqlParameter[] objParamArray = SqlHelperParameterCache.GetCachedParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_ADM_ITEM_MASTER);
if (objParamArray == null)
{
objParamArray = new SqlParameter[]
{
new SqlParameter(PARAM_Item_Id, toObjU_ADM_ITEM_MASTER.Item_Id),
new SqlParameter(PARAM_Item_Name, toObjU_ADM_ITEM_MASTER.Item_Name),
new SqlParameter(PARAM_Item_Desc, toObjU_ADM_ITEM_MASTER.Item_Desc),
new SqlParameter(PARAM_Item_Status, toObjU_ADM_ITEM_MASTER.Item_Status),
new SqlParameter(PARAM_Item_Tentative_Cost, toObjU_ADM_ITEM_MASTER.Item_Source),
new SqlParameter(PARAM_Item_Source, toObjU_ADM_ITEM_MASTER.Item_Source),
new SqlParameter(PARAM_Media_Id_Img, toObjU_ADM_ITEM_MASTER.Media_Id_Img),
new SqlParameter(PARAM_Media_Id_Video, toObjU_ADM_ITEM_MASTER.Media_Id_Video),
new SqlParameter(PARAM_Created_Date, toObjU_ADM_ITEM_MASTER.Created_Date),
new SqlParameter(PARAM_Updated_Date, toObjU_ADM_ITEM_MASTER.Updated_Date),
new SqlParameter(PARAM_Created_by, toObjU_ADM_ITEM_MASTER.Created_by),
new SqlParameter(PARAM_Updated_by, toObjU_ADM_ITEM_MASTER.Updated_by),
};
SqlHelperParameterCache.CacheParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_ADM_ITEM_MASTER, objParamArray);
}
return(objParamArray);
}
