public bool InsertNewCoupon(Coupons Coupon)
{
A_ADM_Coupon_RefDAL obj = new A_ADM_Coupon_RefDAL();
U_ADM_MEDIA_MASTERDAL objImg = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
DateTime now = System.DateTime.Now;
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = Coupon.Coupon_PicUrl;
imgData.Media_Source = "";
imgData.Media_Oth_Dtl = "";
imgData.Created_by = Coupon.Create_By;
imgData.Updated_by = Coupon.Update_By;
imgData.Created_Date = now;
imgData.Updated_Date = now;
Coupon.Coupon_id = Guid.NewGuid().ToString();
Coupon.Create_Date = now;
Coupon.Update_Date = now;
if (objImg.InsertU_ADM_MEDIA_MASTER(imgData))
{
Coupon.Coupon_PicUrl = imgData.Media_Id;
if (obj.InsertCouponDb(Coupon))
{
return(true);
}
}
return(false);
}
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);
}
private void SetParameters(SqlParameter[] U_ADM_MEDIA_MASTERParms, U_ADM_MEDIA_MASTER tobjU_ADM_MEDIA_MASTER)
{
U_ADM_MEDIA_MASTERParms[0].Value = tobjU_ADM_MEDIA_MASTER.Media_Id;
U_ADM_MEDIA_MASTERParms[1].Value = tobjU_ADM_MEDIA_MASTER.Media_Type;
U_ADM_MEDIA_MASTERParms[2].Value = tobjU_ADM_MEDIA_MASTER.Media_File_Location;
U_ADM_MEDIA_MASTERParms[3].Value = tobjU_ADM_MEDIA_MASTER.Media_Source;
U_ADM_MEDIA_MASTERParms[4].Value = tobjU_ADM_MEDIA_MASTER.Media_Oth_Dtl;
U_ADM_MEDIA_MASTERParms[5].Value = tobjU_ADM_MEDIA_MASTER.Created_Date;
U_ADM_MEDIA_MASTERParms[6].Value = tobjU_ADM_MEDIA_MASTER.Updated_Date;
U_ADM_MEDIA_MASTERParms[7].Value = tobjU_ADM_MEDIA_MASTER.Created_by;
U_ADM_MEDIA_MASTERParms[8].Value = tobjU_ADM_MEDIA_MASTER.Updated_by;
}
public bool InsertSubAdmin(A_ModelGroupsList SubAdmin)
{
U_USR_MASTERDAL obj = new U_USR_MASTERDAL();
U_USR_LgnDAL obj1 = new U_USR_LgnDAL();
U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
DateTime now = System.DateTime.Now;
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = SubAdmin.MasterData.Media_Id_Img;
imgData.Media_Source = " ";
imgData.Media_Oth_Dtl = " ";
imgData.Created_by = SubAdmin.MasterData.Created_by;
imgData.Updated_by = SubAdmin.MasterData.Updated_by;
imgData.Created_Date = DateTime.Now;
imgData.Updated_Date = DateTime.Now;
ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData);
SubAdmin.MasterData.Usr_Id = System.Guid.NewGuid().ToString();
SubAdmin.MasterData.Address_Id = 1;
SubAdmin.MasterData.Media_Id_Img = imgData.Media_Id;
SubAdmin.MasterData.Created_Date = DateTime.Now;
SubAdmin.MasterData.Updated_Date = DateTime.Now;
SubAdmin.MasterData.Alt_Email_Id = SubAdmin.LoginData.Email_ID;
SubAdmin.MasterData.Gender = SubAdmin.MasterData.Gender;
SubAdmin.MasterData.About_member = "";
SubAdmin.MasterData.Rating = "1";
SubAdmin.LoginData.Login_Id = System.Guid.NewGuid().ToString();
SubAdmin.LoginData.Usr_Mst_Id = SubAdmin.MasterData.Usr_Id;
SubAdmin.LoginData.Updated_Date = DateTime.Now;
SubAdmin.LoginData.Last_Login_Date = DateTime.Now;
SubAdmin.LoginData.Created_Date = DateTime.Now;
SubAdmin.LoginData.Ip_Address = "";
SubAdmin.LoginData.Login_status = 1;
SubAdmin.LoginData.Created_by = SubAdmin.MasterData.Created_by;
SubAdmin.LoginData.Updated_by = SubAdmin.MasterData.Updated_by;
SubAdmin.MasterData.Date_Of_Birth = DateTime.Now;
SubAdmin.MasterData.Wed_anniversary = DateTime.Now;
if (obj.InsertU_USR_MASTER(SubAdmin.MasterData))
{
if (obj1.InsertU_USR_Lgn(SubAdmin.LoginData))
{
return(true);
}
}
return(false);
}
public bool GetUpdateCoupon(Coupons cou)
{
A_ADM_Coupon_RefDAL couDAL = new A_ADM_Coupon_RefDAL();
Coupons OldData = new Coupons();
Coupons NewData = new Coupons();
U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
OldData = couDAL.GetSingleCouponDetailDb(cou.Coupon_id);
if (!(string.IsNullOrEmpty(cou.Coupon_PicUrl)))
{
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = cou.Coupon_PicUrl;
imgData.Media_Source = " ";
imgData.Media_Oth_Dtl = " ";
imgData.Created_by = cou.Create_By;
imgData.Updated_by = cou.Update_By;
imgData.Created_Date = DateTime.Now;
imgData.Updated_Date = DateTime.Now;
ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData);
NewData.Coupon_PicUrl = imgData.Media_Id;
}
else
{
NewData.Coupon_PicUrl = couDAL.GetCouponMediaIdDb(cou.Coupon_id);
}
NewData.Coupon_id = cou.Coupon_id;
NewData.Coupon_Name = string.IsNullOrEmpty(cou.Coupon_Name) ? OldData.Coupon_Name : cou.Coupon_Name;
NewData.Coupon_VenderName = string.IsNullOrEmpty(cou.Coupon_VenderName) ? OldData.Coupon_VenderName : cou.Coupon_VenderName;
NewData.Coupon_Desc = string.IsNullOrEmpty(cou.Coupon_Desc) ? OldData.Coupon_Desc : cou.Coupon_Desc;
NewData.Coupon_Status = string.IsNullOrEmpty(cou.Coupon_Status) ? OldData.Coupon_Status : cou.Coupon_Status;
NewData.Coupon_StartDate = cou.Coupon_StartDate;
NewData.Coupon_EndDate = cou.Coupon_EndDate;
NewData.Create_By = OldData.Create_By;
NewData.Update_By = cou.Update_By;
NewData.Create_Date = OldData.Create_Date;
NewData.Update_Date = DateTime.Now;
if (couDAL.UpdateCouponMaster(NewData))
{
return(true);
}
return(false);
}
public string UpdateProfile(Profile odetails)
{
try
{
string mediaId = string.Empty;
var userprofile = GetUserProfile(odetails.Usr_Id);
if (!string.IsNullOrEmpty(odetails.Media_Id_Img))
{
mediaId = Guid.NewGuid().ToString();
U_ADM_MEDIA_MASTERDAL omediaDAL = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER omaster = new U_ADM_MEDIA_MASTER();
omaster.Media_Id = mediaId;
omaster.Media_Oth_Dtl = "";
omaster.Media_Source = "";
omaster.Media_Type = "Image";
omaster.Updated_by = odetails.Usr_Id;
omaster.Updated_Date = DateTime.Now;
omaster.Created_by = odetails.Usr_Id;
omaster.Created_Date = DateTime.Now;
omaster.Media_File_Location = odetails.Media_Id_Img;
omediaDAL.InsertU_ADM_MEDIA_MASTER(omaster);
}
U_USR_MASTERDAL ousrDAL = new U_USR_MASTERDAL();
U_USR_MASTER ousr = new U_USR_MASTER();
ousr.Usr_Id = odetails.Usr_Id;
ousr.About_member = string.IsNullOrEmpty(odetails.About_member)?userprofile.About_member:odetails.About_member;
ousr.First_Name = string.IsNullOrEmpty(odetails.First_Name)?userprofile.First_Name:odetails.First_Name;
ousr.Last_Name = string.IsNullOrEmpty(odetails.Last_Name)?userprofile.Last_Name:odetails.Last_Name;
ousr.Gender = string.IsNullOrEmpty(odetails.Gender)?userprofile.Gender:odetails.Gender;
ousr.Is_married = odetails.Is_married;
ousr.Wed_anniversary = string.IsNullOrEmpty(Convert.ToString(odetails.Wed_anniversary))?userprofile.Wed_anniversary:odetails.Wed_anniversary;
ousr.Updated_by = odetails.Usr_Id;
ousr.Updated_Date = DateTime.Now;
ousr.Date_Of_Birth = string.IsNullOrEmpty(Convert.ToString(odetails.Date_Of_Birth))?DateTime.Now:odetails.Date_Of_Birth;
ousr.Created_Date = DateTime.Now;
ousr.Alt_Email_Id = string.IsNullOrEmpty(odetails.Alt_Email_Id)?userprofile.Alt_Email_Id:odetails.Alt_Email_Id;
ousr.Address_Id = string.IsNullOrEmpty(odetails.Address_Id)?userprofile.Address_Id:odetails.Address_Id;
ousr.Media_Id_Img = string.IsNullOrEmpty(mediaId)?userprofile.Extn:mediaId;
ousrDAL.Update_UserProfile(ousr);
return("1");
}
catch
{
return("0"); // 0 indicates unsuccessfull
}
}
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_MEDIA_MASTER(U_ADM_MEDIA_MASTER tobjU_ADM_MEDIA_MASTER)
{
if (tobjU_ADM_MEDIA_MASTER != null)
{
//Get the parameter list needed by the given object
SqlParameter[] lParamArray = GetParameters(tobjU_ADM_MEDIA_MASTER);
SetParameters(lParamArray, tobjU_ADM_MEDIA_MASTER);
//Get the connection
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_MEDIA_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);
}
}
public int GetUpdateEvent(Event eve)
{
U_EVNT_MASTERDAL eveDAL = new U_EVNT_MASTERDAL();
U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
U_EVNT_MASTER NewEveObj = new U_EVNT_MASTER();
var OldEveObj = eveDAL.GetSingleEventDetailsDb(eve.Event_id);
if (!(eve.Event_PicUrl == "/img/default_event.png") && !(string.IsNullOrEmpty(eve.Event_PicUrl)))
{
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = eve.Event_PicUrl;
imgData.Media_Source = " ";
imgData.Media_Oth_Dtl = " ";
imgData.Created_by = eve.Event_Update_by;
imgData.Updated_by = eve.Event_Update_by;
imgData.Created_Date = DateTime.Now;
imgData.Updated_Date = DateTime.Now;
ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData);
NewEveObj.Media_Id_Img = imgData.Media_Id;
}
NewEveObj.Event_Id = string.IsNullOrEmpty(eve.Event_id) ? OldEveObj.Event_id : eve.Event_id;
NewEveObj.Event_Name = string.IsNullOrEmpty(eve.Event_Name) ? OldEveObj.Event_Name : eve.Event_Name;
NewEveObj.Even_Location = string.IsNullOrEmpty(eve.Event_Location) ? OldEveObj.Event_Location : eve.Event_Location;
NewEveObj.Event_Desc = string.IsNullOrEmpty(eve.Event_Desc) ? OldEveObj.Event_Desc : eve.Event_Desc;
NewEveObj.Event_Status = string.IsNullOrEmpty(eve.Event_Status) ? OldEveObj.Event_Status : eve.Event_Status;
NewEveObj.Event_StartDate = eve.Event_StartDate;
NewEveObj.Event_EndDate = eve.Event_EndDate;
NewEveObj.Created_Date = DateTime.Now; //do nothing
NewEveObj.Updated_Date = DateTime.Now;
NewEveObj.Updated_by = eve.Event_Update_by;
NewEveObj.Media_Id_Img = string.IsNullOrEmpty(eve.Event_PicUrl) ? eveDAL.GetEventMediaIdDb(eve.Event_id) : imgData.Media_Id;
return(eveDAL.Update_EventDetailsDb(NewEveObj));
}
private SqlParameter[] GetParameters(U_ADM_MEDIA_MASTER tobjU_ADM_MEDIA_MASTER)
{
SqlParameter[] objParamArray = SqlHelperParameterCache.GetCachedParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_ADM_MEDIA_MASTER);
if (objParamArray == null)
{
//Represents a parameter to a System.Data.SqlClient.SqlCommand,
//and optionally, its mapping to System.Data.DataSet columns.
objParamArray = new SqlParameter[]
{
new SqlParameter(PARAM_Media_Id, tobjU_ADM_MEDIA_MASTER.Media_Id),
new SqlParameter(PARAM_Media_Type, tobjU_ADM_MEDIA_MASTER.Media_Type),
new SqlParameter(PARAM_Media_File_Location, tobjU_ADM_MEDIA_MASTER.Media_File_Location),
new SqlParameter(PARAM_Media_Source, tobjU_ADM_MEDIA_MASTER.Media_Source),
new SqlParameter(PARAM_Media_Oth_Dtl, tobjU_ADM_MEDIA_MASTER.Media_Oth_Dtl),
new SqlParameter(PARAM_Created_Date, tobjU_ADM_MEDIA_MASTER.Created_Date),
new SqlParameter(PARAM_Updated_Date, tobjU_ADM_MEDIA_MASTER.Updated_Date),
new SqlParameter(PARAM_Created_by, tobjU_ADM_MEDIA_MASTER.Created_by),
new SqlParameter(PARAM_Updated_by, tobjU_ADM_MEDIA_MASTER.Updated_by),
};
SqlHelperParameterCache.CacheParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_ADM_MEDIA_MASTER, objParamArray);
}
return(objParamArray);
}
public bool GetUpdateSubAdmin(SubAdmin usr)
{
U_USR_MASTERDAL userDAL = new U_USR_MASTERDAL();
U_USR_LgnDAL logDAL = new U_USR_LgnDAL();
SubAdmin NewData = new SubAdmin();
U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
U_USR_MASTER NewData1 = new U_USR_MASTER();
var OldData = userDAL.GetSingleSubAdminDetailsDb(usr.Usr_Id);
if (!(string.IsNullOrEmpty(usr.Media_File_Location)))
{
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = usr.Media_File_Location;
imgData.Media_Source = " ";
imgData.Media_Oth_Dtl = " ";
imgData.Created_by = usr.Created_by;
imgData.Updated_by = usr.Updated_by;
imgData.Created_Date = DateTime.Now;
imgData.Updated_Date = DateTime.Now;
ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData);
NewData.Media_File_Location = imgData.Media_Id;
}
else
{
NewData.Media_File_Location = userDAL.GetMemberMediaIdDb(usr.Usr_Id);
}
NewData.Usr_Id = usr.Usr_Id;
NewData.First_Name = string.IsNullOrEmpty(usr.First_Name) ? OldData.First_Name : usr.First_Name;
NewData.Last_Name = string.IsNullOrEmpty(usr.Last_Name) ? OldData.Last_Name : usr.Last_Name;
NewData.Alt_Email_Id = string.IsNullOrEmpty(usr.Alt_Email_Id) ? OldData.Alt_Email_Id : usr.Alt_Email_Id;
NewData.Gender = string.IsNullOrEmpty(usr.Gender) ? OldData.Gender : usr.Gender;
NewData.Usr_role_Id = string.IsNullOrEmpty(Convert.ToString(usr.Usr_role_Id)) ? OldData.Usr_role_Id : usr.Usr_role_Id;
NewData.Mobile_Number = string.IsNullOrEmpty(usr.Mobile_Number) ? OldData.Mobile_Number : usr.Mobile_Number;
NewData.Login_status = string.IsNullOrEmpty(Convert.ToString(usr.Login_status)) ? OldData.Login_status : usr.Login_status;
NewData.Created_Date = OldData.Created_Date;
NewData.Updated_Date = DateTime.Now;
NewData.Created_by = OldData.Created_by;
NewData.Updated_by = string.IsNullOrEmpty(usr.Updated_by) ? OldData.Updated_by : usr.Updated_by;
NewData1.Usr_Id = NewData.Usr_Id;
NewData1.First_Name = NewData.First_Name;
NewData1.Last_Name = NewData.Last_Name;
NewData1.Gender = NewData.Gender;
NewData1.Usr_role_Id = NewData.Usr_role_Id;
NewData1.Media_Id_Img = NewData.Media_File_Location;
NewData1.Updated_Date = NewData.Updated_Date;
NewData1.Updated_by = NewData.Updated_by;
NewData1.Date_Of_Birth = DateTime.Now;
NewData1.Wed_anniversary = DateTime.Now;
NewData1.Created_Date = DateTime.Now;
bool status = logDAL.UpdateMobileStatusDb(NewData.Usr_Id, NewData.Mobile_Number, NewData.Login_status, NewData.Updated_Date, NewData.Updated_by);
status = userDAL.Update_SubAdminProfileDb(NewData1);
return(true);
}
