public int Insert(string code, string name, int numbercode)
{
if (string.IsNullOrEmpty(code))
{
SetError(98, "Invalid currency code");
return(Error_Number);
}
if (string.IsNullOrEmpty(name))
{
SetError(98, "Invalid currency name");
return(Error_Number);
}
if (numbercode == 0)
{
SetError(98, "Invalid currency number code");
return(Error_Number);
}
Currency_Info ccyInfo = new Currency_Info();
ccyInfo.Code = code;
ccyInfo.Name = name;
ccyInfo.NumberCode = numbercode;
if (base.Insert(ccyInfo) != 0)
{
SetError(0, String.Empty);
}
else
{
SetError(99, Error_Message);
}
return(Error_Number);
}
public static int Update(Currency_Info obj)
{
if (obj != null)
{
return(dal_ccy.Update(obj.Code, obj.Name, obj.NumberCode));
}
else
{
throw new Exception(dal_ccy.Error_Message);
}
}
//**********************************************************************************
public SqlCommand EditOneCurrency(Currency_Info objCurrency_Info)
{
SqlCommand command = new SqlCommand("Update Currency Set Code= @Code,Name= @Name, NumberCode = @NumberCode Where Code= @Code");
command.CommandType = CommandType.Text;
command.Parameters.Add("@Code", SqlDbType.NVarChar, 3).Value = objCurrency_Info.Code;
command.Parameters.Add("@Name", SqlDbType.NVarChar, 45).Value = objCurrency_Info.Name;
command.Parameters.Add("@NumberCode", SqlDbType.Int).Value = objCurrency_Info.NumberCode;
this.AddCommand(command);
return(command);
}
public SqlCommand CreateOneCurrency(Currency_Info objCurrency_Info)
{
SqlCommand command = new SqlCommand("insert into Currency(Code, Name, NumberCode) Values(@Code, @Name, @NumberCode)");
command.CommandType = CommandType.Text;
command.Parameters.Add("@Code", SqlDbType.NVarChar, 3).Value = objCurrency_Info.Code;
command.Parameters.Add("@Name", SqlDbType.NVarChar, 45).Value = objCurrency_Info.Name;
command.Parameters.Add("@NumberCode", SqlDbType.Int).Value = objCurrency_Info.NumberCode;
this.AddCommand(command);
return(command);
}
protected int Delete(Currency_Info obj)
{
if (obj == null)
{
throw new Exception("Invalid data input");
}
_dalCcy.RemoveOneCurrency(obj.Code);
if (_dalCcy.Execute())
{
return(_dalCcy.LastRecordsEffected);
}
throw _dalCcy.GetException;
}
protected int Insert(Currency_Info obj)
{
if (obj == null)
{
throw new Exception("Invalid data input");
}
_dalCcy.CreateOneCurrency(obj);
if (_dalCcy.Execute())
{
return(_dalCcy.LastRecordsEffected);
}
throw _dalCcy.GetException;
}
private Currency_Info GenerateObj(DataRow ordCurrency)
{
if (ordCurrency == null)
{
throw new Exception("Invalid data row");
}
Currency_Info objCurrency_Info = new Currency_Info();
if (ordCurrency["Code"] != DBNull.Value)
{
objCurrency_Info.Code = Convert.ToString(ordCurrency["Code"]);
}
if (ordCurrency["Name"] != DBNull.Value)
{
objCurrency_Info.Name = Convert.ToString(ordCurrency["Name"]);
}
if (ordCurrency["NumberCode"] != DBNull.Value)
{
objCurrency_Info.NumberCode = Convert.ToInt32(ordCurrency["NumberCode"]);
}
return(objCurrency_Info);
}
public int Delete(string code)
{
if (string.IsNullOrEmpty(code))
{
SetError(98, "Invalid currency code");
return(Error_Number);
}
Currency_Info ccyInfo = base.GetCurrencyById(code);
if (ccyInfo == null)
{
SetError(99, "Currency not find");
return(Error_Number);
}
if (base.Delete(ccyInfo) != 0)
{
SetError(0, String.Empty);
}
else
{
SetError(99, Error_Message);
}
return(Error_Number);
}
public int Update(string code, string name, int numbercode)
{
if (string.IsNullOrEmpty(code))
{
SetError(98, "Invalid currency code");
return(Error_Number);
}
if (string.IsNullOrEmpty(name))
{
SetError(98, "Invalid currency name");
return(Error_Number);
}
if (numbercode == 0)
{
SetError(98, "Invalid currency number code");
return(Error_Number);
}
Currency_Info ccyInfo = base.GetCurrencyById(code);
if (ccyInfo == null)
{
SetError(99, "Currency not find");
return(Error_Number);
}
ccyInfo.Name = name;
ccyInfo.NumberCode = numbercode;
if (base.Update(ccyInfo) != 0)
{
SetError(0, String.Empty);
}
else
{
SetError(99, Error_Message);
}
return(Error_Number);
}
