public string UpdateIsDeletePackage(PackageBO package, int packageID, int isDelete)
{
string result = "";
//PackageBO package = new PackageBO();
int statusNew = -1;
if (isDelete == 1)
{
statusNew = 0;
}
else
{
statusNew = 1;
}
package.IsDelete = statusNew;
package.DeleteDate = DateTime.Now;
package.DeleteUser = (string)Session["FullName"];
bool rs = Packagerepository.UpdateIsDeletePackage(package, packageID, statusNew);
if (rs)
{
result = "success";
}
return(result);
}
public bool InsertPackage(PackageBO package)
{
bool row = false;
string fileLog = Path.GetDirectoryName(Path.Combine(pathLog));
try
{
row = Proxy.InsertPackage(package);
}
catch (Exception ex)
{
Utility.WriteLog(fileLog, ex.Message);
}
return(row);
}
public bool UpdateIsDeletePackage(PackageBO package, int packageID, int isDelete)
{
bool row = false;
string fileLog = Path.GetDirectoryName(Path.Combine(pathLog));
try
{
row = Proxy.UpdateIsDeletePackage(package, packageID, isDelete);
}
catch (Exception ex)
{
Utility.WriteLog(fileLog, ex.Message);
}
return(row);
}
public bool UpdatePackage(PackageBO package, int packageID)
{
string fileLog = Path.GetDirectoryName(Path.Combine(pathLog, "Logs"));
Sqlhelper helper = new Sqlhelper("", "ConnectionString");
try
{
SqlParameter[] pa = new SqlParameter[6];
string sql = "SP_UpdatePackage";
pa[0] = new SqlParameter("@packageID", packageID);
pa[1] = new SqlParameter("@packageName", package.PackageName);
pa[2] = new SqlParameter("@packageValue", package.PackageValue);
pa[3] = new SqlParameter("@isActive", package.IsActive);
//pa[2] = new SqlParameter("@isDelete", package.IsDelete);
//pa[3] = new SqlParameter("@createDate", package.CreateDate);
//pa[4] = new SqlParameter("@createUser", package.CreateUser);
pa[4] = new SqlParameter("@updateDate", package.UpdateDate);
pa[5] = new SqlParameter("@updateUser", package.UpdateUser);
//pa[7] = new SqlParameter("@deleteDate", package.DeleteDate);
//pa[8] = new SqlParameter("@deleteUser", package.DeleteUser);
SqlCommand command = helper.GetCommand(sql, pa, true);
//adminID = Convert.ToInt32(command.ExecuteScalar());
//return adminID;
int row = command.ExecuteNonQuery();
bool rs = false;
if (row > 0)
{
rs = true;
}
return(rs);
}
catch (Exception ex)
{
Utilitys.WriteLog(fileLog, "Exception update package : " + ex.Message);
return(false);
}
finally
{
helper.destroy();
}
}
public IEnumerable <PackageBO> ListAllPackage(int start, int end)
{
string fileLog = Path.GetDirectoryName(Path.Combine(pathLog, "Logs"));
Sqlhelper helper = new Sqlhelper("", "ConnectionString");
try
{
List <PackageBO> lstPackage = new List <PackageBO>();
string sql = "SP_ListAllPackage";
SqlParameter[] pa = new SqlParameter[2];
pa[0] = new SqlParameter("@start", start);
pa[1] = new SqlParameter("@end", end);
SqlCommand command = helper.GetCommand(sql, pa, true);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
PackageBO package = new PackageBO();
package.PackageID = int.Parse(reader["PackageID"].ToString());
package.PackageName = reader["PackageName"].ToString();
package.PackageValue = double.Parse(reader["PackageValue"].ToString());
package.IsActive = int.Parse(reader["IsActive"].ToString());
package.IsDelete = int.Parse(reader["IsDelete"].ToString());
package.CreateDate = DateTime.Parse(reader["CreateDate"].ToString());
package.CreateUser = reader["CreateUser"].ToString();
package.UpdateDate = DateTime.Parse(reader["UpdateDate"].ToString());
package.UpdateUser = reader["UpdateUser"].ToString();
package.DeleteUser = reader["DeleteUser"].ToString();
package.DeleteDate = DateTime.Parse(reader["DeleteDate"].ToString());
package.TotalRecord = int.Parse(reader["TOTALROWS"].ToString());
lstPackage.Add(package);
}
return(lstPackage);
}
catch (Exception ex)
{
Utilitys.WriteLog(fileLog, ex.Message);
return(null);
}
finally
{
helper.destroy();
}
}
public bool UpdateIsDeletePackage(PackageBO package, int packageID, int isDelete)
{
string fileLog = Path.GetDirectoryName(Path.Combine(pathLog, "Logs"));
Sqlhelper helper = new Sqlhelper("", "ConnectionString");
try
{
bool rs = false;
string sql = "SP_DeletePackage";
SqlParameter[] pa = new SqlParameter[4];
pa[0] = new SqlParameter("@packageID", packageID);
//pa[1] = new SqlParameter("@packageName", package.PackageName);
pa[1] = new SqlParameter("@isDelete", isDelete);
pa[2] = new SqlParameter("@deleteDate", package.DeleteDate);
pa[3] = new SqlParameter("@deleteUser", package.DeleteUser);
SqlCommand command = helper.GetCommand(sql, pa, true);
int row = command.ExecuteNonQuery();
if (row > 0)
{
rs = true;
}
return(rs);
}
catch (Exception ex)
{
Utilitys.WriteLog(fileLog, ex.Message);
return(false);
}
finally
{
helper.destroy();
}
}
public string SavePackage(int packageID, string packageName, double packageValue)
{
string result = "";
PackageBO package = new PackageBO();
if (Session["Emailmember"] == null)
{
Response.Redirect("/login");
}
if (packageID > 0)
{
try
{
package.PackageName = packageName;
package.PackageValue = packageValue;
package.IsActive = 1;
package.UpdateDate = DateTime.Now;
package.UpdateUser = (string)Session["FullName"];
bool updatePackage = Packagerepository.UpdatePackage(package, packageID);
if (updatePackage)
{
result = "Updatesuccess";
}
else
{
result = "Updatefaile";
}
}
catch { result = "Erorr"; }
}
else if (packageID == 0)
{
try
{
package.PackageName = packageName;
package.PackageValue = packageValue;
package.IsActive = 1;
package.IsDelete = 0;
package.CreateDate = DateTime.Now;
package.CreateUser = (string)Session["FullName"];
//package.DeleteDate = DateTime.Parse("1/1/1990");
//package.DeleteUser = "";
//package.UpdateDate = DateTime.Parse("1/1/1990");
//package.UpdateUser = "";
bool checkExitsPackageName = Packagerepository.CheckPackageNameExists(packageName);
if (checkExitsPackageName)
{
result = "PackageNameExist";
}
else
{
bool insert = Packagerepository.InsertPackage(package);
if (insert)
{
result = "Updatesuccess";
}
else
{
result = "Updatefaile";
}
}
}
catch { result = "Erorr"; }
}
//else if(result=="delete")
//{
// try
// {
// package.PackageName = packageName;
// package.IsDelete = 0;
// package.DeleteDate = DateTime.Now;
// package.DeleteUser = (string)Session["FullName"];
// bool updatePackage = Packagerepository.UpdatePackage(package, packageID);
// if (updatePackage)
// {
// result = "Updatesuccess";
// }
// else
// {
// result = "Updatefaile";
// }
// }
// catch { result = "Erorr"; }
//}
return(result);
}
