public bool UpdateTemplate(DesignDetails Design)
{
SqlParameter[] Parameter = new SqlParameter[] {
new SqlParameter("@Title", Design.Title),
new SqlParameter("@Discription", Design.Discription),
new SqlParameter("@App_Category_Id", Design.CategoryID),
new SqlParameter("@CategoryName", Design.CategoryName),
new SqlParameter("@Tag", Design.Tag),
new SqlParameter("@Price", Design.Price),
new SqlParameter("@YoutubeVideoEnable", Design.YoutubeEnable.ToString().ToLower()),
new SqlParameter("@YoutubeVideoLink", Design.YoutubeLink),
new SqlParameter("@SEO", Design.SEO.ToString().ToLower()),
new SqlParameter("@VersionUpgrade", Design.Version.ToString().ToLower()),
new SqlParameter("@SpeedOptimization", Design.SpeedOptimization.ToString().ToLower()),
new SqlParameter("@Testing", Design.Testing.ToString().ToLower()),
new SqlParameter("@Support", Design.Support.ToString().ToLower()),
new SqlParameter("@imgaePath", Design.imgaePath),
new SqlParameter("@imageSize", Design.imageSize),
new SqlParameter("@PublicMode", Design.PublicMode.ToString().ToLower())
};
bool ReturnVal = __Check.ExcutionNonQuery(@"update System_Template set
Title=@Title,Discription=@Discription,App_Category_Id=@App_Category_Id,
CategoryName=@CategoryName,Tag=@Tag,Price=@Price,YoutubeVideoEnable=@YoutubeVideoEnable,
YoutubeVideoLink=@YoutubeVideoLink,SEO=@SEO,VersionUpgrade=@VersionUpgrade,SpeedOptimization=@SpeedOptimization,
Testing=@Testing,Support=@Support,imgaePath=@imgaePath,imageSize=@imageSize,PublicMode=@PublicMode where Template_Id=" + Design.TemplateId, Parameter);
ErrorMessege = __Check.Messege;
return(ReturnVal);
}
private bool _Private_DesignUpload(DesignDetails Design)
{
if (AppsPermision(Design.RegID))
{
StringGenarator _Random = new StringGenarator();
_Random.Number = true;
_Random.ApperCase = true;
_Random.TotalString = __Settings.Get_InValue_Settings(10002);//hou much number
var tid = _Random.RandomStringNumber("tid");
DateTimeZone __datetime = new DateTimeZone(Design.Offset);
SqlParameter[] Parameter = new SqlParameter[] {
new SqlParameter("@RegID", Design.RegID),
new SqlParameter("@Title", Design.Title),
new SqlParameter("@Discription", Design.Discription),
new SqlParameter("@App_Category_Id", Design.CategoryID),
new SqlParameter("@CategoryName", Design.CategoryName),
new SqlParameter("@Tag", Design.Tag),
new SqlParameter("@Price", Design.Price),
new SqlParameter("@DatabaseOwn", "true"),
new SqlParameter("@DB_ID", __Settings.Get_InValue_Settings(3)),
new SqlParameter("@YoutubeVideoEnable", Design.YoutubeEnable.ToString().ToLower()),
new SqlParameter("@YoutubeVideoLink", Design.YoutubeLink),
new SqlParameter("@OpenDate", __datetime.DateTimes()),
new SqlParameter("@PublishDate", ""),
new SqlParameter("@SEO", Design.SEO.ToString().ToLower()),
new SqlParameter("@VersionUpgrade", Design.Version.ToString().ToLower()),
new SqlParameter("@SpeedOptimization", Design.SpeedOptimization.ToString().ToLower()),
new SqlParameter("@Testing", Design.Testing.ToString().ToLower()),
new SqlParameter("@Support", Design.Support.ToString().ToLower()),
new SqlParameter("@Published", "false"),
new SqlParameter("@EditAccess", "true"),
new SqlParameter("@tid", tid),
new SqlParameter("@imgaePath", Design.imgaePath),
new SqlParameter("@imageSize", Design.imageSize),
new SqlParameter("@PublicMode", Design.PublicMode.ToString().ToLower())
};
bool returnValue = __Check.ExcutionNonQuery(@"insert into System_Template (RegID,Title,Discription,App_Category_Id,CategoryName,Tag,Price,DatabaseOwn,DB_ID,YoutubeVideoEnable,YoutubeVideoLink,OpenDate,PublishDate,SEO,VersionUpgrade,SpeedOptimization,Testing,Support,Published,EditAccess,tid,imgaePath,imageSize,PublicMode)
values(@RegID,@Title,@Discription,@App_Category_Id,@CategoryName,@Tag,@Price,@DatabaseOwn,@DB_ID,@YoutubeVideoEnable,@YoutubeVideoLink,@OpenDate,@PublishDate,@SEO,@VersionUpgrade,@SpeedOptimization,@Testing,@Support,@Published,@EditAccess,@tid,@imgaePath,@imageSize,@PublicMode)", Parameter);
Template_ID = __Check.stringCheck("select Template_Id from System_Template where tid='" + tid + "'");
ErrorMessege = __Check.Messege;
return(returnValue);
}
else
{
ErrorMessege = "Your are create your maximam application now you can't create. please buy creadit!";
return(false);
}
}
public List <DesignDetails> GetTemplateData(string RegID)
{
List <DesignDetails> Details = new List <DesignDetails>();
SqlDataReader dr = __Check.SqlDataReader("select * from System_Template where RegID=" + RegID);
while (dr.Read())
{
DesignDetails design = new DesignDetails()
{
TemplateId = dr["Template_Id"].ToString(),
tid = dr["tid"].ToString(),
RegID = dr["RegID"].ToString(),
Title = dr["Title"].ToString(),
Discription = dr["Discription"].ToString(),
CategoryID = dr["App_Category_Id"].ToString(),
CategoryName = dr["CategoryName"].ToString(),
Tag = dr["Tag"].ToString(),
Price = Convert.ToDouble(dr["Price"].ToString()),
DatabaseOwn = dr["DatabaseOwn"].ToString().ToLower() == "true" ? true : false,
DB_ID = dr["DB_ID"].ToString(),
YoutubeEnable = dr["YoutubeVideoEnable"].ToString().ToLower() == "true"?true:false,
YoutubeLink = dr["YoutubeVideoLink"].ToString(),
OpenDate = dr["OpenDate"].ToString(),
PublishDate = dr["PublishDate"].ToString(),
SEO = dr["SEO"].ToString().ToLower() == "true"?true:false,
Version = dr["VersionUpgrade"].ToString().ToLower() == "true"?true:false,
SpeedOptimization = dr["SpeedOptimization"].ToString().ToLower() == "true" ? true : false,
Testing = dr["Testing"].ToString().ToLower() == "true" ? true : false,
Support = dr["Support"].ToString().ToLower() == "true" ? true : false,
Published = dr["Published"].ToString().ToLower() == "true" ? true : false,
EditAccess = dr["EditAccess"].ToString().ToLower() == "true" ? true : false,
ver = dr["version"].ToString(),
versionDetails = dr["versionDetails"].ToString(),
imgaePath = dr["imgaePath"].ToString(),
imageSize = Convert.ToDouble(dr["imageSize"].ToString()),
PublicMode = dr["PublicMode"].ToString().ToLower() == "true" ? true : false
};
Details.Add(design);
}
return(Details);
}
public bool InsertTemplate(DesignDetails Design)
{
return(_Private_DesignUpload(Design));
}