private AccountRoles_Info GenerateObject(DataRow row)
{
AccountRoles_Info objAccountRolesInfo = new AccountRoles_Info();
if (row == null)
{
throw new Exception("DataRow not be empty");
}
if (row["ID"] != DBNull.Value)
{
objAccountRolesInfo.ID = Convert.ToInt32(row["ID"]);
}
if (row["Name"] != DBNull.Value)
{
objAccountRolesInfo.Name = Convert.ToString(row["Name"]);
}
if (row["Account_ID"] != DBNull.Value)
{
objAccountRolesInfo.Account_ID = Convert.ToString(row["Account_ID"]);
}
if (row["Type"] != DBNull.Value)
{
objAccountRolesInfo.Type = (AccountRoleType)Enum.Parse(typeof(AccountRoleType), row["Type"].ToString());
}
if (row["Operator"] != DBNull.Value)
{
objAccountRolesInfo.Operator = (OperatorType)Enum.Parse(typeof(OperatorType), row["Operator"].ToString());
}
if (row["Value"] != DBNull.Value)
{
objAccountRolesInfo.Value = Convert.ToDecimal(row["Value"]);
}
if (row["Seq"] != DBNull.Value)
{
objAccountRolesInfo.Seq = Convert.ToInt32(row["Seq"]);
}
if (row["Active"] != DBNull.Value)
{
objAccountRolesInfo.Active = Convert.ToBoolean(row["Active"]);
}
if (row["Active_Date"] != DBNull.Value)
{
objAccountRolesInfo.Active_Date = Convert.ToDateTime(row["Active_Date"]);
}
if (row["CreateDate"] != DBNull.Value)
{
objAccountRolesInfo.CreateDate = Convert.ToDateTime(row["CreateDate"]);
}
if (row["Last_Update"] != DBNull.Value)
{
objAccountRolesInfo.Last_Update = Convert.ToDateTime(row["Last_Update"]);
}
if (row["UserCreated"] != DBNull.Value)
{
objAccountRolesInfo.UserCreated = Convert.ToString(row["UserCreated"]);
}
return(objAccountRolesInfo);
}
public static int Update(AccountRoles_Info obj)
{
if (obj != null)
{
return(dal_ac_roles.Update(obj));
}
else
{
throw new Exception(dal_ac_roles.Error_Message);
}
}
public SqlCommand CreateOne(AccountRoles_Info objAccountRolesInfo)
{
SqlCommand command = new SqlCommand("INSERT INTO Account_Roles("
+ "Name, "
+ "Account_ID, "
+ "Type, "
+ "Operator, "
+ "Value, "
+ "Seq, "
+ "Active, "
+ "Active_Date, "
+ "CreateDate, "
+ "Last_Update, "
+ "UserCreated "
+ ")"
+ "VALUES ("
+ "@Name, "
+ "@Account_ID, "
+ "@Type, "
+ "@Operator, "
+ "@Value, "
+ "@Seq, "
+ "@Active, "
+ "@Active_Date, "
+ "@CreateDate, "
+ "@Last_Update, "
+ "@UserCreated "
+ ")");
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.Parameters.Add("@Name", SqlDbType.NVarChar, 150).Value = objAccountRolesInfo.Name;
command.Parameters.Add("@Type", SqlDbType.NVarChar, 50).Value = objAccountRolesInfo.Type;
command.Parameters.Add("@Account_ID", SqlDbType.NVarChar, 50).Value = objAccountRolesInfo.Account_ID;
command.Parameters.Add("@Value", SqlDbType.Decimal).Value = objAccountRolesInfo.Value;
command.Parameters.Add("@Seq", SqlDbType.Int).Value = objAccountRolesInfo.Seq;
command.Parameters.Add("@Operator", SqlDbType.NVarChar, 50).Value = objAccountRolesInfo.Operator;
command.Parameters.Add("@Active", SqlDbType.Bit).Value = objAccountRolesInfo.Active;
if (objAccountRolesInfo.Active)
{
command.Parameters.Add("@Active_Date", SqlDbType.DateTime).Value = objAccountRolesInfo.Active_Date;
}
else
{
command.Parameters.Add("@Active_Date", SqlDbType.DateTime).Value = DBNull.Value;
}
command.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = objAccountRolesInfo.Active_Date;
command.Parameters.Add("@Last_Update", SqlDbType.DateTime).Value = objAccountRolesInfo.Active_Date;
command.Parameters.Add("@UserCreated", SqlDbType.NVarChar, 25).Value = objAccountRolesInfo.Active_Date;
this.AddCommand(command);
return(command);
}
private void CreateRole()
{
AccountRoles_Info ari = new AccountRoles_Info();
ari.Name = doc.SelectSingleNode("//request/name").InnerText;
ari.Type = (AccountRoleType)Enum.Parse(typeof(AccountRoleType), doc.SelectSingleNode("//request/type").InnerText);
ari.Operator = (OperatorType)Enum.Parse(typeof(OperatorType), doc.SelectSingleNode("//request/operation").InnerText);
ari.Seq = int.Parse(doc.SelectSingleNode("//request/seq").InnerText);
ari.UserCreated = "sa";
ari.Value = Decimal.Parse(doc.SelectSingleNode("//request/value").InnerText);
ari.Last_Update = DateTime.Now;
ari.Active = true;
ari.Active_Date = DateTime.Now;
ari.Account_ID = doc.SelectSingleNode("//request/account_id").InnerText;
ari.CreateDate = DateTime.Now;
BaseRole baseRole = new BaseRole();
baseRole.CreateRole(ari);
}
public SqlCommand EditOne(AccountRoles_Info objAccountRolesInfo)
{
SqlCommand command = new SqlCommand("UPDATE Account_Roles SET "
+ "Name = @Name, "
+ "Account_ID = @Account_ID, "
+ "Type = @Type, "
+ "Operator = @Operator, "
+ "Value = @Value, "
+ "Seq = @Seq, "
+ "Active = @Active, "
+ "Active_Date = @Active_Date, "
+ "CreateDate = @CreateDate, "
+ "Last_Update = @Last_Update, "
+ "UserCreated = @UserCreated "
+ "WHERE ID = @ID");
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.Parameters.Add("@ID", SqlDbType.Decimal).Value = objAccountRolesInfo.ID;
command.Parameters.Add("@Name", SqlDbType.NVarChar, 150).Value = objAccountRolesInfo.Name;
command.Parameters.Add("@Type", SqlDbType.NVarChar, 50).Value = objAccountRolesInfo.Type;
command.Parameters.Add("@Account_ID", SqlDbType.NVarChar, 50).Value = objAccountRolesInfo.Account_ID;
command.Parameters.Add("@Value", SqlDbType.Decimal).Value = objAccountRolesInfo.Value;
command.Parameters.Add("@Seq", SqlDbType.Int).Value = objAccountRolesInfo.Seq;
command.Parameters.Add("@Operator", SqlDbType.NVarChar, 50).Value = objAccountRolesInfo.Operator;
command.Parameters.Add("@Active", SqlDbType.Bit).Value = objAccountRolesInfo.Active;
if (objAccountRolesInfo.Active)
{
command.Parameters.Add("@Active_Date", SqlDbType.DateTime).Value = objAccountRolesInfo.Active_Date;
}
else
{
command.Parameters.Add("@Active_Date", SqlDbType.DateTime).Value = DBNull.Value;
}
command.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = objAccountRolesInfo.CreateDate;
command.Parameters.Add("@Last_Update", SqlDbType.DateTime).Value = objAccountRolesInfo.Last_Update;
command.Parameters.Add("@UserCreated", SqlDbType.NVarChar, 25).Value = objAccountRolesInfo.UserCreated;
this.AddCommand(command);
return(command);
}
public new int Update(AccountRoles_Info acRoleInfo)
{
if (acRoleInfo == null)
{
SetError(98, "Invalid data input");
return(Error_Number);
}
if (string.IsNullOrEmpty(acRoleInfo.Account_ID))
{
SetError(98, "Account_ID is null or empty");
return(Error_Number);
}
if (string.IsNullOrEmpty(acRoleInfo.Name))
{
SetError(98, "Name is null or empty");
return(Error_Number);
}
if (Convert.ToInt32(acRoleInfo.Seq) == 0)
{
SetError(98, "Seq is null or empty");
return(Error_Number);
}
if (string.IsNullOrEmpty(acRoleInfo.Operator.ToString()))
{
SetError(98, "Operater is null or empty");
return(Error_Number);
}
if (string.IsNullOrEmpty(acRoleInfo.Type.ToString()))
{
SetError(98, "Type is null or empty");
return(Error_Number);
}
if ((acRoleInfo.Active == true) && (acRoleInfo.Active_Date == DateTime.MinValue))
{
SetError(98, "Active Date is null or empty");
return(Error_Number);
}
if (acRoleInfo.CreateDate == DateTime.MinValue)
{
SetError(98, "CreateDate is null or empty");
return(Error_Number);
}
if (acRoleInfo.Last_Update == DateTime.MinValue)
{
SetError(98, "Last_Update is null or empty");
return(Error_Number);
}
if (string.IsNullOrEmpty(acRoleInfo.UserCreated))
{
SetError(98, "UserCreated is null or empty");
return(Error_Number);
}
var oldAcRoleInfo = _dalAcRoles.GetOne(acRoleInfo.ID);
if (oldAcRoleInfo == null)
{
SetError(99, string.Format("Account role {0} not find", acRoleInfo.ID));
return(Error_Number);
}
if (base.Update(acRoleInfo) != 0)
{
SetError(0, String.Empty);
}
else
{
SetError(99, _dalAcRoles.GetException.Message);
}
return(Error_Number);
}
