public string CreateBudget(Budgetcode Bcobj)
{
cmd = new SqlCommand("spInsertNewBudget", con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BudgetName", Bcobj.BudgetName);
//cmd.Parameters.AddWithValue("@Budgetdescription ", Bcobj.Budgetdescription);
cmd.Parameters.AddWithValue("@BudgetStartDate ", Bcobj.BudgetStartDate);
cmd.Parameters.AddWithValue("@BudgetEndDate ", Bcobj.BudgetEndDate);
cmd.Parameters.AddWithValue("@SOStartDate ", Bcobj.SOStartDate);
cmd.Parameters.AddWithValue("@SOEndDate ", Bcobj.SOEndDate);
cmd.Parameters.AddWithValue("@ApproverStartDate ", Bcobj.ApproverStartDate);
cmd.Parameters.AddWithValue("@ApproverEndDate ", Bcobj.ApproverEndDate);
cmd.Parameters.AddWithValue("@Active ", Bcobj.Active);
cmd.Parameters.AddWithValue("@CreatedBy ", Bcobj.CreatedBy);
/*The output parameter*/
cmd.Parameters.Add("@BudgetCode", SqlDbType.VarChar, 100);
cmd.Parameters["@BudgetCode"].Direction = ParameterDirection.Output;
/*End*/
int count = cmd.ExecuteNonQuery();
string data = Convert.ToString(cmd.Parameters["@BudgetCode"].Value);
con.Close();
cmd = new SqlCommand();
if (count != 0)
{
return(data);
}
else
{
return(data);
}
}
public bool CreateBudget(Budgetcode Bcobj)
{
cmd = new SqlCommand("spInsertNewBudget", con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BudgetName", Bcobj.BudgetName);
cmd.Parameters.AddWithValue("@Budgetdescription ", Bcobj.Budgetdescription);
cmd.Parameters.AddWithValue("@BudgetStartDate ", Bcobj.BudgetStartDate);
cmd.Parameters.AddWithValue("@BudgetEndDate ", Bcobj.BudgetEndDate);
cmd.Parameters.AddWithValue("@SOStartDate ", Bcobj.SOStartDate);
cmd.Parameters.AddWithValue("@SOEndDate ", Bcobj.SOEndDate);
cmd.Parameters.AddWithValue("@ApproverStartDate ", Bcobj.ApproverStartDate);
cmd.Parameters.AddWithValue("@ApproverEndDate ", Bcobj.ApproverEndDate);
cmd.Parameters.AddWithValue("@Active ", Bcobj.Active);
cmd.Parameters.AddWithValue("@CreatedBy ", Bcobj.CreatedBy);
int count = cmd.ExecuteNonQuery();
con.Close();
if (count != 0)
{
return(true);
}
else
{
return(false);
}
}
