public String AddModifyBannerDetails(ClsBannerDetails ObjBannerDetails)
{
using (ClsMasterManagement_DAL obj = new ClsMasterManagement_DAL())
{
return(obj.AddModifyBannerDetails(ObjBannerDetails));
}
}
public string AddModifyBannerDetails(ClsBannerDetails ObjBannerDetails)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@Ref_Banner_ID", ObjBannerDetails.Ref_Banner_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@BannerTitle", ObjBannerDetails.BannerTitle, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@BannerPageName", ObjBannerDetails.BannerPageName, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Descripation", ObjBannerDetails.Descripation, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@IsActive", ObjBannerDetails.IsActive, DbType.Boolean);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@CreatedBy", ObjBannerDetails.CreatedBy, DbType.String);
ObJParameterCOl.Add(objDBParameter);
DBHelper objDbHelper = new DBHelper();
Int64 Ref_Banner_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.AddModifyBannerDetails, ObJParameterCOl, CommandType.StoredProcedure));
if (Ref_Banner_ID > 0)
{
ObjBannerDetails.FileManager.ForEach(File =>
{
DBParameterCollection ObJParameterCOl1 = new DBParameterCollection();
DBParameter objDBParameter1 = new DBParameter("@FileManagerID", File.FileManagerID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleID", Ref_Banner_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleType", File.ModuleType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileIdentifier", File.FileIdentifier, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileName", File.FileName, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FilePath", File.FilePath, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileExtension", File.FileExtension, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileType", File.FileType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSize", File.FileSize, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSequence", File.Sequence, DbType.Int32);
ObJParameterCOl1.Add(objDBParameter1);
objDbHelper.ExecuteScalar(Constant.SaveModuleFile, ObJParameterCOl1, CommandType.StoredProcedure).ToString();
});
}
if (Ref_Banner_ID > 0 && ObjBannerDetails.Ref_Banner_ID == 0)
{
return("BANNERADDED");
}
else if (Ref_Banner_ID > 0 && ObjBannerDetails.Ref_Banner_ID > 0)
{
return("BANNERUPDATED");
}
else
{
return("BANNEREXISTS");
}
}
catch (Exception ex)
{
throw ex;
}
}
