public object AddImprovement(AddImprovement addImpr)
{
dynamic TBAddImprovementResult;
int str = -1;
try
{
Imgname Result = Improvement.createImprovement(addImpr);
if (!string.IsNullOrEmpty(Result.imgName))
{
str = GlobalFuns.UploadImage(addImpr.grpID, Result.imgName, "Improvement");
}
else
{
str = 0;
}
if (Result != null)
{
if (str == 0)
{
TBAddImprovementResult = new { status = "0", message = "success" };
if (addImpr.improvementID != "0")
{
string url = ConfigurationManager.AppSettings["imgPath"] + "php/EditImprovement.php?AnnID=" + addImpr.improvementID;
// GroupMaster.Send(url);
}
}
else
{
TBAddImprovementResult = new { status = "1", message = "failed" }
};
}
else
{
TBAddImprovementResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBAddImprovementResult = new { status = "1", message = "failed" };
}
return(new { TBAddImprovementResult });
}
public static Imgname createImprovement(AddImprovement imp)
{
try
{
if (string.IsNullOrEmpty(imp.improvementID))
{
imp.improvementID = "0";
}
if (string.IsNullOrEmpty(imp.inputIDs))
{
imp.inputIDs = "";
}
var imprID = new MySqlParameter("?imprID", imp.improvementID);
var imprType = new MySqlParameter("?imprType", imp.imprType);
var imprTitle = new MySqlParameter("?imprTitle", imp.improvementTitle);
var imprDesc = new MySqlParameter("?imprDesc", string.IsNullOrEmpty(imp.improvementDesc) ? "" : imp.improvementDesc);
var memID = new MySqlParameter("?memID", imp.memID);
var grpID = new MySqlParameter("?grpID", imp.grpID);
var memprofileIDs = new MySqlParameter("?memprofileIDs", imp.inputIDs);
var imprImg = new MySqlParameter("?ImprovementImg", string.IsNullOrEmpty(imp.improvementImg) ? "0" : imp.improvementImg);
var sendSMSAll = new MySqlParameter("?sendSMSAll", string.IsNullOrEmpty(imp.sendSMSAll) ? "0" : imp.sendSMSAll);
var sendSMSNonSmartPh = new MySqlParameter("?sendSMSNonSmartPh", string.IsNullOrEmpty(imp.sendSMSNonSmartPh) ? "0" : imp.sendSMSNonSmartPh);
var publishDate = new MySqlParameter("?publishDate", imp.publishDate);
var expiryDate = new MySqlParameter("?expiryDate", imp.expiryDate);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreQuery <Imgname>("CALL V4_USPAddImprovement(?imprID,?imprType,?imprTitle,?imprDesc,?memID,?grpID,?memprofileIDs,?ImprovementImg,?publishDate,?expiryDate,?sendSMSAll,?sendSMSNonSmartPh)",
imprID, imprType, imprTitle, imprDesc, memID, grpID, memprofileIDs, imprImg, publishDate, expiryDate, sendSMSAll, sendSMSNonSmartPh).SingleOrDefault();
//var Result = 1;
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
GC.Collect();
}
}
